Put fifty pieces on your Shopify store in one import.
Shopify's own product CSV, every column of the current template by its exact name, with the antiques fields added as metafield columns: material, origin, period, dimensions, restoration, provenance. Dropdowns wherever Shopify has a set value, the product category and Google Shopping already filled for furniture, and three example pieces to copy from. Fill it, save as CSV, import it under Products.
- Every column of Shopify's current product CSV by its exact name, so the import preview shows no unknown columns
- Material, origin, period, dimensions, restoration and provenance as metafield columns, named the way Shopify names them, so each product page can show them
- Published, status, continue selling, weight unit and Google's condition as dropdowns, so a typo never fails a row
- Product category and Google product category filled with the furniture paths, and the cost per item column there, so Shopify shows your margin
Your spreadsheet is ready
Download the Shopify product sheet for antiquesYou get the file now. No automatic emails: we may write to you once, personally.
What's in the file
Shopify's columns, by Shopify's names, finished with your fields and the values Shopify expects.
Products
One row per item: every column of Shopify's current product CSV, then the 6 antiques fields as metafield columns, named the way Shopify names them. Hover a header and it explains itself.
Dropdowns and checks
A dropdown wherever Shopify has a set value: published, status, continue selling, the weight unit, Google's condition, and every field with choices. Prices and quantities take numbers only.
Fields guide and Start here
Each metafield column with its Shopify type and its choices, and the five import steps, including the one-time metafield definitions.
What it looks like
The Products sheet with the example rows. Blue headers are Shopify's columns worth filling, violet ones your fields as metafields.
Plus 57 more columns: the handle, description, vendor, tags, photos, weight, Google Shopping, and the other fields. The metafield headers carry Shopify's full name in the file.
How to import it
- 1
Fill the rows
One row per item. Pick from the dropdowns and paste your photo addresses. Make the metafield definitions once under Settings, Custom data, Products, or delete the columns you don't want.
- 2
Save as CSV
File, Save as, CSV UTF-8. In Google Sheets, File, Download, CSV.
- 3
Import under Products
Products, Import, choose the file. Shopify previews what it will create before it does, and tells you about any row it cannot read.
The same fields, written to Shopify from one card, and to every other channel with it.
A sheet puts an item on Shopify once. Sellevry writes these fields to Shopify as metafields from the item's card and lists it on eBay and the other channels together, ends the others when it sells, and keeps the stock straight. When you get there, send us the sheet and we move it in, free.
Questions
Is this Shopify's template or yours?
Shopify's columns, by Shopify's names and in its order, as its help page "Using CSV files to import and export products" defines them. We add the metafield columns for antiques, the dropdowns, the notes on each header and the example rows.
What are the metafield columns?
Shopify stores a piece's period, material and the rest as metafields, named custom.period and so on; the column header carries that name in brackets, the way Shopify writes it. Make a product metafield definition with the same name once, under Settings, Custom data, Products, and the import fills it. A column you don't want can be deleted.
How do I import it?
Save the Products sheet as CSV (File, Save as, CSV UTF-8). In Shopify, open Products, then Import, choose the file, and check the preview. Shopify shows what it will create before it does.
What about pairs and sets?
A pair of chairs sold together is one product with a quantity of 1, as the example rows show; a set you would split is one product per piece. Shopify's variants are for sizes and colours of the same product, which a one-of-a-kind piece doesn't have.
Does it work in Google Sheets?
Yes. The dropdowns and the checks come across. Download it from Google Sheets as CSV before you import.
What does Sellevry do that the sheet cannot?
The sheet puts a piece on Shopify once. Sellevry writes these same fields to Shopify as metafields from one card and lists the piece on eBay, Etsy and Instagram with it, ends the others when it sells, and keeps the stock straight across the shop, the booths and all of them. When you get there, send us the sheet and we move it in.