All Categories Items Update Items in Bulk

Update Items in Bulk

In this guide, we will show you how to update items in bulk. This is useful when you want to modify several items at once.

1. Click on "Catalog" and select "Download"

This will download your item catalog

2. Open the CSV file and update the information

IMPORTANT: Do not remove the item ID (the first column). Doing so will duplicate the articles instead of updating them.

Follow these tips to complete the template:

1. Do not remove or modify the value for the first column named "Id"

2. If you want to "Deactivate" the item replace the value "FALSE" to "TRUE"

3. Update the information you want to modify

  1. To apply multiple discounts or taxes, separate the values with a comma ','. For example, entering '5,10' will add a 5% and a 10% discount. Similarly, when specifying tax names, use commas to separate them. In the 'Tax' column, follow the same order to correctly assign each value to the corresponding tax.

  2. If you've added custom fields, create a new column with the field name and input values based on the existing options. Note that attempting to add a value not found in the options will result in empty information. This rule applies to all 'Field Types' except for text input."

  3. You can add new items, just leave the first column value empty.

3. Upload the CSV document with your data

Once you have finish updating the document, upload it from your computer.

4. Map the column titles with the available fields in your Osmos workspace

Osmos will automatically match table titles with available fields in your Osmos workspace that share the same titles as in your document (e.g., matching "item name" with "item name").

For fields that are not correctly matched or remain unmatched, you can manually map them by selecting the corresponding field within your Osmos workspace. For instance, if your file contains a column with the title "item," you can specify where that column's data will be stored in your Osmos workspace, such as "item name."

You can skip columns by not matching them to existing fields in Osmos. The data will be left blank."

5. CSV file confirmation

You will get a sample of the records you are uploading. Here, you will be able to view how many rows and columns will be uploaded.

Click "Continue"

6. Add a tag

You can add a tag to identify the items you are uploading. To proceed, please check the box to acknowledge that the file you are uploading may take a couple of minutes to become available.

Click "Continue"