Menu

How to clean a supplier product CSV before importing to Shopify
📰

How to clean a supplier product CSV before importing to Shopify

DEV Community·Zijian Xiao·9 days ago
#bAQCXi4i
#dev#title#supplier#price#file
Reading 0:00
15s threshold

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 .…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.