Bulk Product registratio（Excel）
Creating a Bulk Create Template
DEXTRE is a user-defined type system.
First, we must create an import template set up for the data we wish to import.
※ A sample template, already filled out, is available to download below.
Click on ① ‘Products‘ followed by ② ‘Import Templates‘.
You will be redirected to the following page.
Select ① ‘Bulk Create Products’, followed by ② ‘Create New Bulk Create Template’
■ We can now create an import template set up for the data we wish to import.（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テンプレート
④ Selectable Metadata Select all metadata (Custom Properties) you wish to have available to the products you are going to import.
⑤ Enter theNumber 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, enter2
Even selecting 2, not every product will need to be in two, or even any category when you import the information.
⑥ Enter theNumber Of Materialsyou 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 enter3
Even selecting 3, not every product will need to have three, or even any materials when you import the information.
■ You can customize the header names to your liking.
After customizing the ① Column Names to your liking,click on ② ‘Create’.
Downloading the excel template
■ Excel templates can be downloaded from Import Templates
Select, ①‘Bulk Create Products‘ the click ②‘Download‘ for the applicable template.
a file with the name product_bulk_create_import_日付OOOO-O-OO.xlsx will be downloaded.
A sample template, already filled in, can be downloaded below.
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 to ① ‘Products‘, then click ② ‘Bulk Import 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.
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