I have read previous discussions and understand there is no way to have multiple SKUs for one product - I have two different fulfillment locations for one product (one location is DropShip warehouse, one location is In-Store) - Each fulfillment location uses their own SKU… which then is impossible to upload for example: a CSV file to update the product quantity for that specific location.
Example:
Blue T-Shirt
Warehouse Sku - ABC123-S
In-Store Sku - ABC1234Z-S
My store currently has around 8,000 product variants that need continuous quantity updates for each location. Is there a way to upload a CSV and have it recognize the correct Product Name and place the updated quantity in the correct location name?
It is not possible to have multiple SKUs for one product in Shopify. However, there are some workarounds that you can use to manage your inventory between your two fulfillment locations.
One option is to use the “Location” feature in Shopify to track inventory levels for each of your fulfillment locations. You can set up each of your fulfillment locations as a separate location in Shopify and then assign inventory to each location. This way, you can track inventory levels separately for each location and adjust them as needed.
When you upload a CSV file to update your inventory, you can use the product variant ID or barcode to identify the correct variant and update the inventory level for the appropriate location. You can also use the “inventory_quantity” and “location_id” fields in your CSV file to specify the inventory level and the location ID for each variant.
Alternatively, you can use a third-party app like Stocky or TradeGecko to manage your inventory and stock levels for each location. These apps can integrate with your Shopify store and allow you to manage inventory across multiple locations and update your stock levels with a CSV file.
I hope this helps. Let me know if you have any further questions.
If the Inventory CSV file has matching product handles but different SKUs, then the inventory levels will be updated for the products with the matching handles, but the SKUs will not be updated.
In other words, if you have a product with a certain handle and SKU, and you update the inventory levels for that product using a CSV file that has the same handle but a different SKU, the inventory levels for the product with the matching handle will be updated, but the SKU will remain the same as before.
So, it’s important to ensure that the SKUs in your CSV file match the SKUs of the products in your store, otherwise the inventory levels will be updated for the wrong products or the SKUs will not be updated.
Makes sense - ok thank you! I’m trying to figure out a way to add a specific product Metafield where I can add the secondary SKU & name information - do you think this would be recognized? Thank you again for your help
Yes, adding a product metafield for the secondary SKU and name information can be a good solution to make sure that the correct products are being updated with the correct inventory levels.
To add a product metafield, you can go to the product in your Shopify admin, click on the “More actions” dropdown, and then select “Add metafield”. From there, you can enter a key and value for the metafield, such as “Secondary SKU” and the SKU value, respectively.
Once you have added the metafield to your product, you can use the Shopify API to update the inventory levels for the product based on the secondary SKU value. You can also use the secondary SKU value as a reference point for updating inventory levels in your CSV file.
Note that you’ll need to make sure that the CSV file you are using includes the secondary SKU value in order for this approach to work correctly. You may also need to use a custom script or app to update the inventory levels based on the secondary SKU value, as this is not a standard feature in Shopify.
Ok works great - I have added a custom Variant Metafield to add the secondary sku, but I noticed this metafield column does not show up on the Product Export CSV file… what am I missing? Thank you so much, Mics, this is a huge help. Also, how would I set up the Shopify API to recognize the secondary sku metafield? Thank you
Thank you!!