I run a Shopify store according to the careful inventory tracking. I get CSV files from manufacturers that have multiple columns. The first column is always style number. The second column is always the color of the dress, and then the next 10 columns are usually the sizes, ranging from 00 all the way up to 26, with two digits in between, so comma, it’s 00, 2, 4, 6, and so forth. What is the most efficient way that I can automate this process of tracking inventory? I have tried plugins, but I can’t seem to find one that works.
every app I find can only do it by sku,. But the manufacturer that sends me the file does not do that..
their data looks like (starting with style no:
style no: 200 color: red 00 quantity 0; 0 quantity 1; 2 quantity 2, etc
1 Like
The most efficient way is to ask them to provide a unique identifier (sku, barcode, ID, etc). Then you can map that unique identifier to the sku in your system, and use a chart to identify them, or you could build a custom app to upload the spreadsheet, then it would cross check the mapping and update the Shopify inventory.
If they won’t add a unique identifier, then you could create the mapping system yourself (If column A = X and column B = Y, then SKU = ABC123, etc). Then if you wanted to automate the checking and inventory updating you could build a custom app to do that.
I can’t imagine an existing app does that, because it’s a unique situation with the sku mapping, but maybe an inventory tracking app could build a custom plugin for you, rather than building a custom app.
I should be able to build out a workflow for you to do that using our app mesa.
Highly interested! I love mesa. Do you guys charge extra to build the automations?
Oh sweet. In general the team does charge for complicated workflow builds. But in my role as the platform advocate, I don’t. I try to repurpose as much of what I build for demo content though (not sharing any private information of course).
Perfect! How do I go about reaching out to you guys? I found a temporary solution but it’s a bandaid pretty much
You can message me here or email kalen@getmesa.com