By Zijian Xiao
A supplier spreadsheet can look perfectly readable and still need work before you import it. Product names sit under unfamiliar headers, a price uses a decimal comma, and an SKU has lost its leading zeros. The difficult part is deciding which changes are safe to automate and which require a decision about the underlying product.
Here is a spreadsheet workflow first, followed by a small, reproducible conversion example. The example uses synthetic supplier data that I actually ran through Rowmoss's local Python conversion code. It is a file-conversion test; I did not test an import into a live Shopify store.
Start with a copy and a narrow import goal
Keep the supplier's original file unchanged. Work on a copy, and decide what one row means before changing headers. For this walkthrough, each row represents one new product with one default variant .…