Your product list: import, export, clone and delete
Manage many products at once: find products without a picture, download your products as a CSV spreadsheet, add many products from a CSV file, and copy or delete products.
Watch it done: a short silent video with captions · 0:59. The steps below show the same thing picture by picture.
Before you start
Log in as the site owner.
Open ADMIN › eCommerce › Products.
Products without pictures
1
Step 1. The Products tab lists your products. Edit is on each row; Clone and Delete are under the ··· (More) button.
2
Step 2. Above the list you see how many products have no picture. Re-fetch media for products missing images looks pictures up again for them.
3
Step 3. Tick Show only products missing images to list just those; untick it to see all.
Export
4
Step 4. Export to CSV downloads your products as a spreadsheet file (Item ID, Model Number, Name, Price, In Stock, Created, Updated).
Import from a CSV file
5
Step 5. Import from CSV adds many products at once from a spreadsheet saved as CSV.
6
Step 6. Choose your CSV file.
7
Step 7. Click Next.
8
Step 8. Choose Import new products, or Update existing products.
9
Step 9. Map CSV Columns: for each field, check which column of your file it comes from. Name and Price are required; columns with the same names are matched for you.
10
Step 10. Below are options: look products up by their model number to add pictures and details, use the looked-up names and descriptions, and update a matching product instead of creating a duplicate. The price from your file is always kept. Click Import.
11
Step 11. The imported products are in the list.
Clone and delete
12
Step 12. ··· (More), then Clone makes a copy of a product, to change with Edit.
13
Step 13. The copy is in the list.
14
Step 14. ··· (More), then Delete removes a product after you confirm.
Check it worked
Open your store in a private window and check the imported products, their prices and pictures.
Good to know
Before a big import, export your products first: the file shows the column names the import understands.