Update Shopify Product Stock and Price with StoreRobo

StoreRobo Import Export Suite is the ultimate solution for all your Shopify import/export requirements. This guide provides detailed instructions on updating Shopify’s product stock and price via StoreRobo and key considerations to ensure a smooth and efficient update process.

You can download a sample CSV file from the link given below. This will serve as a blueprint for structuring your own CSV file. The provided sample file includes a product example with variations. Since your import will likely have many more products, remember to remove the sample product and its variations before using the file for your import.

Getting your data into Shopify starts with a well-formatted CSV file. Think of it as a checklist for your products. Naming the columns clearly and carefully inputting each data is very important since incorrect formatting can cause the import process to fail. To make things easy, we’ve included a sample CSV file. Use it as a guide to format your own file and avoid any import hiccups.

When updating products using a CSV file, the only required columns are Handle and Title. These columns identify the products in the store.

While updating products via a CSV file, although you only need the Title and Handle columns as mandatory, certain columns’ data relies on others. For instance, when updating variant-related columns like Variant Price and Variant Inventory Qty, their data depends on the corresponding variant details. In this case, you must also include the Option1 Name and Option1 Value columns to identify each variant.

Without Option1 Name and Option1 Value columns, a new default variant will be created, and existing variants will be deleted.

• When a non-required column in the import CSV file is blank, the product list keeps its original value without any updates.
• If the CSV file omits a non-required column that already exists in the product list, the product list retains its existing value.

• Identify the products you want to update and key in the Handle and Title of the products in the Sample CSV file.
• Key in the Option1 Name and Option1 Value.
• If the product doesn’t have any variants, set the Option1 Name value as Title and Option1 Value as Default Title.
• Once the CSV file is configured, follow the standard update process.

1. Install StoreRobo Import Export Suite.
2. Under the import section, select the import file.
3. Select the data type as products and click on Proceed.
4. Select an import template, set up filters, and select the import options.

In the 2nd step of the import process where you select the Options, make sure to check the options Ignore ID and Update If products exist in the store so that the products will be updated based on the product handle.

Finally, click on Import to begin the import process.