Shopify App - Bulk update items via csv file upload

Once the products have been added to your store the only thing that will continue to be updated is the stock quantity. Therefore from time to time you may need to update the products in bulk. This can include:

1. Cost price changes.
   
2. Sale price changes.
3. Status updates eg. if products are discontinued change to "archived".
   
4. Add tags to help organise the products.
   
5. Change the name or description of items.
   

Follow the steps below to bulk update your products.

1. Export your products. Navigate to Shopify > Products > Export.  Click to export your products.

2. In the dialog box select "All products" then "Export Products"

3. Open the file in a spreadsheet application like Microsoft Excel.

4. Remove all rows and columns that are not required using the sort or filter functions.

Rows

Each image has a separate row. The only row required for the import contains the SKU. All other rows can be deleted. 

Columns

The only mandatory columns required for the import are: 

1. Handle
   
2. Title
   
3. Variant SKU
   

All other columns can be deleted. Include other columns that you wish to edit the data of like Tags, Status, Cost per item or Variant Price (your sale price). If you are not updating all products the use a VLOOKUP function to filter the required items.

5. Populate the sheet with the new data that is required for the update. For example if you are removing discontinued items the sheet would look like this:

If updating sale prices:

6. Once complete save the sheet as CSV format. 

7. Navigate to Shopify > Products > Import.  Click to Import your products.

8. Select your saved CSV file.

9. Tick the box "Overwrite products with matching handles." This must be selected or the products will not be updated.

10. Click "Upload and preview" and check the data looks correct then click "Import products".

11. The products will then begin importing. The more products that are on the sheet the longer it will take. For example 2,000 products will take 2-3 hours. 

12. Shopify will send an email summary when the import is complete and detail any failures.

Please contact us if you need any more help or guidence. 

• Related Articles

• Shopify App

  The Geko Products Shopify app streamlines the whole process of selling our fantastic range of products. Features include: Add all or selected products in one click to your Shopify store. Once added the stock quantities will remain synced. Send orders ...

• How to Bulk Order using a CSV file?

  Question: I'm looking at submitting an order via Bulk Order using a CSV file but have some questions on how to populate some of the fields. As above in the table, follow the simple instructions below to fill out the fields in a bulk order CSV file : ...

• Shopify App - Process orders

  When you get an order for one of our products you simply click "Request Fulfilment" on the order to send it to us. The order will then be sent to us with all the required details for us to process and dispatch your order. The system will also ...

• How to install the Geko Shopify App

  Go to the Shopify app store to add and install the Geko App. Click here Click to add app and install the app. Now the app is installed you can see it here: It will also show in the integrations section of the Geko Dropship site. Your account is now ...

• Shopify App - Add products to your store

  With your Shopify store set up and the Geko App installed you are now ready to add our products and start selling. Go to the integrations section of our site and select sync products. You now have two options: Sync all products Sync only selected ...