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.
How to Set Up Column-Based Quantity Mapping
Go to App → Feed Settings → Step 2: Matching Column
- Map Primary Identifier: Select your product or variant identifier (e.g., SKU, Barcode, or Parent SKU) in Step 2: Matching Column.
- Assign Quantity Columns: In Step 2: Matching Column, map the corresponding quantity columns from your supplier file to the Shopify Quantity field.
- 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.
Qty_S, Qty_M, Qty_L).
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.
Format Type | File Structure Example | Processing Method | |||
|---|---|---|---|---|---|
Standard Row-Based | `SKU-S | Qty: 10 | Qty: 15 | 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.
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
0rather than text characters likeN/Aor dashes (-).
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
- [How to Update Inventory for Multiple Locations] → Learn how to route stock updates to different warehouses and fulfillment centers.
- [Quantity Field Smart Settings] → Explore additional quantity controls, buffer rules, and inventory threshold settings.
Updated on: 04/11/2026
Thank you!
