Catalog Management
Prepare and Upload your Catalog
The following procedure details the steps required to prepare and upload your catalog .
Step 1. Prepare Your Catalog
Before uploading your Catalog you need to prepare a CSV file with detailed information about your store products.
This information is used by Global-e to check for restrictions and to assign an HS code to each product. For this reason, it is very important that the information is inserted in the correct fields and in the correct formats, following the guidelines below.
You can prepare your catalog by using a template provided by your Project Manager or you can set up your own CSV file.
To set up your CSV file:
Open an Excel spreadsheet and save it as a CSV file, using the following naming conventions:
{MerchantName}_product-catalogue_ddmmyyyyhhmm.csv
Example: MyToysStore_product-catalogue_100220151738.csv
Name the columns exactly as listed in the table below, following the same order, and include all mandatory headers.
Example of a CSV file with column headers:
Field Names and Descriptions
Headers/Fields | Description | Field Type | Mandatory on Initial Upload | Mandatory in Ongoing Updates |
|---|---|---|---|---|
ID-SKU | Enter the Product SKU as it appears in your product catalog. The SKU may not include spaces. | String | Yes | Yes |
Display_Name | Product name as displayed on the website. | String | Yes | Yes |
Product_Description | The product description as it is displayed on the website. | String | Yes | Yes |
Material / Composition | Describe the composition of the product.
| String (no limit) | Yes | No |
Product_Weight | The product's weight in grams, including the packaging. The value should be the Gross Weight including packaging. The measurement units are grams. | Decimal | Yes (Mandatory only when shipping DG). | |
Is Blocked | The product is blocked in all countries operated by Global-e. Optional values:
| bit | Yes, (If the merchant does not specify it, Global-e will add and classify it in the catalog) | No |
Parent_Product_ID (Only for SFCC merchants) | The SKU of the Product parent SKU (The master product, if it exists). | String | No | No |
Product_HS_Code | The Commodity Code. An international term for the classification of products, to classify traded goods for customs purposes. HS codes are assigned by the Global-e classification team for merchants who shipped with Global-e carriers. | String | No. It is not always available on the merchant side as part of the catalog If Yes, then the Global-e Classification team will validate If No, then Global-e will assign HS code (based on composition) | No |
Product_Categories | The product category. | String (50) | No | No |
Height | Product height measurement. In cm. | Decimal | No | No |
Width | Product width, in centimeters. | Decimal | No | No |
Length | The product's length, in centimetres. | Decimal | No | No |
Volume | The product's net volume, in cubic centimeters. | Decimal | No Net Volume is mandatory only for dangerous goods | No Net Volume is mandatory only for dangerous goods |
Country_of_Origin | Country where the product is manufactured. The COO must be provided for tax calculation. If it is not specified then a default COO is assigned.
| String | Yes | Yes |
Image_URL | A link to an image of the product | String | Yes | No |
Is_DG? | Indication of whether the product is considered a Dangerous Good. | bit (1) | Yes. Mandatory for merchants shipping dangerous goods with Global-e via DHL. | No |
Kids products (if applicable) | If it is part of the product description. (Filled by Global-e) | bit (1) | Yes, for the initial upload, if it is part of the catalog. (Global-e runs an automated process for ongoing classification, to flag new kids' SKUs, and special HS codes are applied). | No |
Price | Product price in the default merchant currency | Decimal | No | No |
Size | Product size
| String (3) | No | No |
Colour | Product color | String | No | No |
Product_URL | URL of the product page | String | No | No |
Step 2. Populate Your Catalog
To populate your catalog:
Add your list of products, one product per row with the relevant information in the relevant column, according to the Field Names and Descriptions detailed in Step 1.
Important
Do not include commas in the prices you list in the CSV file as this may cause parsing errors.
When done, save your CSV file.
Note
When enabling editing in your CSV file, your security settings may change the CSV file format to Excel. Make sure to save your file back to CSV before uploading it to Global-e.
Step 3. Submit your Catalog for Approval
After you have completed filling out your catalog you need to send it to your Project Manager for approval.
The Global-e Clarification team reviews your CSV file to ensure the formatting is correct. They also check for product restrictions and assign an HS code to each item.
If there are any mistakes within the file, it will be sent back to you to be corrected. Once you make the correction you return it to your Project Manager so that it can be reviewed again.
This process continues until the catalog meets the requirements necessary to be uploaded to your site.
Step 4. Upload your Catalog
After your catalog is approved, Global-e provides you with a username and password for the SFTP server so that you can upload your catalog to the server.