13. Update Some Products Data (i.e. Quantity and Price Values Only) and do not Change the Other Details During Import

Prepare the file to import with the main product data. It should contain the following columns:

  • "Product ID"

  • "Product Quantity"

  • "Product Price"

  • "Product Name"

  • "Product description"

  • "Category Path" etc.

Run the Import/Export Products wizard . On the "Import File Name" page specify the path to a file you want to use in importing.

Import File Name

Move to the next step and choose correct delimiters to separate the values in a file.

Preview .csv File

On the "Fields Delimiters and Additional Settings" step, check the additional conditions for importing.

Fields Delimeters and Additional Settings

Then, select store view where the changes made during importing will be reflected.

Select Store View to Import Products to

The "Base Formats" page displays the main date and time format and basic separators used for numerical values.

Base Formats

Pay attention to the "Assign .csv Columns to Database Fields" step of import. You should link columns from a file you want to be updated to the relevant fields of your store database.

Assign .csv Columns to Database Fields

Note: only assigned data will be transferred or modified!

Do not forget to choose the identifier - SKU or ID. This helps Store Manager to recognize the data that is importing to the store database.

Identify Product by

The "Preview" page allows you to see what data will be modified when the process is completed.

The next step - "Import Options" - allows choosing an action you want to perform with transferred data. In our example, "Modify only" is selected.

Import Options

Start import with the [Import] button, and wait till you get the results on the summary step.

Preview Import Result

To check modified data, open the "Products" page of Store Manager. There are the latest changes in the price values and product inventory. The other product details remain unchanged after import.