General Settings

Importing data into DEXTRE

Bulk Updating Products

Creating a Bulk Update Products template

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’

For example,

❶ Category 1 : Mens > Subcategory 1 : Outer > Subsubcategory 1 : Jacket

❷Category 2 : Collaboration

In a case like the above where you wish to apply those categories to a single product, enter 2

Even entering 2, not every product will need to be in two, or even any category when you import the information.

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’

For example,

❶  Material_PartsName1 :Main / Material_Name1 : Wool 50% Cotton 50% / Material_Type1 : KNIT

❷ Material_PartsName2 :Lining / Material_Name2 : Cupra 100% / Material_Type2 : WOVEN

❸ Material_PartsName3 :Sleeve Lining / Material_Name3 : Cupra 100% / Material_Type3 : WOVEN

In the above case enter 3

Even entering 3, not every product will need to have three, or even any materials when you import the information.

Downloading the excel template

■ 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.

Uploading the completed excel template

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 toProducts‘, then click Bulk Update Products‘.

Click onSelect 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.

If after this your products are still not visible, refresh the page

For Windows「F5」
For Mac「Command」+「R」

If you have any questions, please contact us using the
 Inquiry form

If you are in a hurry or need assistance by phone, please contact us at

 +81-6-6534-6111

 
pagetop