Check a supplier batch for Shopify drafts
Check new supplier products against your store SKUs, hold incomplete rows and download a draft import file with a review log.
Start here
Use supplier columns SKU, Title, Price and Image URL; other columns may remain. Add your current store SKU list to keep existing items out of the new-product draft. The ZIP separates rows ready for a draft from rows that need a correction. This happens in your browser and does not change your Shopify store.
See an example input (made-up data)
SKU,Title,Price,Image URL A01,Blue cap,12.50,https://example.com/a.jpg B02,Old cap,9.99,https://example.com/b.jpg
Your result
Add your input, then use the button to see your result here.
What this can and cannot do
The draft import CSV contains only new rows with a unique SKU, title, positive price and HTTPS image URL; the Status is draft and online-store publication is false. Other rows stay in the review log with the source row and reason. An HTTPS URL is not proof that an image exists or that you can use it. SKUs or titles starting with spreadsheet formula characters are held for manual review so their values are not silently changed in the import file. Check all supplier prices, images, rights, variants and product details before importing. This tool does not fetch images, check Shopify live data, edit inventory, set taxes, publish products or run an import. CSV and tab-separated text up to 2 MB and 1,000 data rows per input. Store exports with an old Variant SKU heading are accepted; an inventory-only export with no SKU/Variant SKU column is not. Shopify may change its import format; compare the draft with your current store export and its official import instructions.
Something missing or not working?
Tell us what happened or what would make this more useful. Only the message you write here is sent. Please leave out private files, passwords and customer details. You do not need to give an email address. This suggestion form cannot show replies. Use a private help request if you need a reply.