Articles on: Frequently Asked Questions (FAQ)

Does the column based format support quantity?

Yes, syncX: Stock Sync supports column-based quantity formats where inventory quantities are distributed horizontally across multiple columns (such as separate columns for different sizes, colors, or inventory locations). If your source file is organized in this structure, you can map the matching identifier and reach out to our team for assisted setup.


Available on: ✔️ Add | ✔️ Update



How to Set Up Column-Based Quantity Mapping


Go to App → Feed Settings → Step 2: Matching Column


  1. Map Primary Identifier: Select your product or variant identifier (e.g., SKU, Barcode, or Parent SKU) in Step 2: Matching Column.
  2. Assign Quantity Columns: In Step 2: Matching Column, map the corresponding quantity columns from your supplier file to the Shopify Quantity field.
  3. Contact Support for Configuration: Reach out to our technical support team or executive via live chat to activate the custom column-based quantity parser for your feed.


Ensure that each quantity column header in your feed file has a consistent and unique name (e.g., Qty_S, Qty_M, Qty_L).


Column-Based Quantity Example



Column-Based Format Detailed Breakdown


1. Column-Based vs. Standard Row-Based Formats

Most standard inventory files use a row-based format where every variant has its own row. In a column-based format, a single product row contains multiple quantity columns representing individual variant or location quantities.


Column-based formats are common when suppliers present products by style code with sizes displayed horizontally across spreadsheet columns.


Format Type

File Structure Example

Processing Method




Standard Row-Based

`SKU-S

Qty: 10<br>SKU-M

Qty: 15<br>SKU-L

Qty: 20`

Standard 1-to-1 row mapping

Column-Based (Variants)

`Style-101

Qty_S: 10

Qty_M: 15

Qty_L: 20`

Unpivots columns to match Shopify variant options

Column-Based (Locations)

`SKU-101

LocA_Qty: 50

LocB_Qty: 25`

Routes column quantities to corresponding Shopify locations



2. Assisted Configuration Requirement

Because column-based data requires unpivoting multiple headers into distinct Shopify variant or location IDs, a specialized backend mapping profile must be applied to your feed.


Map your initial identifier column first before messaging support so our team can immediately inspect your file structure.


Contact our support team with your Feed ID and a description of which columns correspond to which variants or locations.



Key Rules & Technical Details


  • Header Consistency: Header names for each quantity column must remain fixed. If your supplier renames column headers, the mapping will break.
  • Empty Values: If a column cell is blank, ensure your supplier file leaves it empty or inputs 0 rather than text characters like N/A or dashes (-).
Priority rule: Column-based quantity feeds require backend activation by Stock Sync technical staff before automated scheduled runs can process the split columns correctly.



Troubleshooting Steps


  • Issue: Only one column's quantity is updating in Shopify while others are ignored. → Solution: Standard mapping only handles a single quantity column at a time. Contact support to enable multi-column quantity parsing on your feed.
  • Issue: Quantities are being assigned to the wrong variant sizes. → Solution: Verify that the order of the quantity columns in your source file matches the order of the variant options defined in your Shopify admin.
  • Issue: Feed fails with an invalid numeric value error. → Solution: Check your quantity columns for non-numeric symbols, text notes (such as Out of stock), or currency signs, and apply quantity rules or ask support to sanitize the input.



Good Articles to Continue


Updated on: 04/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!