Bulk Updating Products

DEXTRE is a user-defined type system.

First, we must create an import template set up for the data we wish to update.

Click on ① ‘Products‘ followed by ② ‘Import Templates‘.

You will be redirected to the following page.

Select ① ‘Bulk Update Products‘, followed by ② ‘Create New Bulk Update Template‘

■ We can now create an import template set up for the data we wish to update.（Not everything that can be selected is required to be, only select the types of data you wish to import).

① ‘Template No.‘ Set a name here.

② ‘Selectable Taxes‘ Enable this if you wish to apply Taxes.

③ Select an ‘SKU Template‘

④ ‘Selectable Metadata‘ Select all metadata (Custom Properties) you wish to have available to the products you are going to import.

⑤ Enter the ‘Number of Category Groups‘ to add during import.

※A Category group is defined as one set of ‘Category -> Subcategory -> subsubcategory’

⑥ Enter the ‘Number Of Materials‘ you wish to have available to the products you are going to import.

※A Material is defined as one set of ‘Material Type -> Material Name -> Material Parts Name’

■ Excel templates can be downloaded from Import Templates

Select, ①‘Bulk Update Products‘ the click ②‘Download‘ for the applicable template.

a file with the name product_bulk_update_import_DateOOOO-O-OO.xlsx will be downloaded.

Next, after ① filtering the products to find the ones you wish to update, ② select them. If you put a check in the top checkbox, all the products filtered will be selected. Finally, click on ③ Download.

In the downloaded excel file, update or add the information you wish to.

After downloading the excel import template file, complete it with the appropriate data and then follow the below steps  and upload it to DEXTRE.

Go to ① ‘Products‘, then click ② ‘Bulk Update Products‘.

Click on ① ‘Select a XLSX File‘

Select the completed excel template,

then click the ②‘Import‘ button.

If you see【更新完了しました】at the bottom of your screen, you have successfully imported your products.