Bulk Create Products
This tutorial shows you how to bulk upload new product listings in TREX using the Bulk Upload template. This process is also used for mass creation of multiple SKUs.
Filled Template Examples
⚠️ Note: The sample templates below are for reference only. Please download your own template and fill in your product information accordingly.
- Beauty:
📄 Skincare Products (Grouped) - Wine & Spirits:
📄 Whisky Products - Electronics:
📄 Audio Products (Grouped)
Steps to mass create products
Step 1: Generate a template
- Go to Products ➡️ Add New Products ➡️ Bulk Upload of Multiple Products
- Select the Product Category E.g., Beauty ➡️ All Perfumes ➡️ All Her Perfumes
⚠️ Once the product has been created, the category cannot be changed. You will need to delete and re-create the product listing if you wish to change the category.
- Generate And Download Template
- Check the Downloads folder
Step 2: How to fill up product information in the template
Generic Attributes
- Fields with (EN), (ZH) require both English and Chinese translations. If the Chinese translation is not available, please copy the English text over.
- Do not include external links in the Description and Additional Description fields.
| Fields | What to Fill Up | Status |
|---|---|---|
| Category | Select from the drop-down list. | Mandatory |
| Brand | Enter the brand name. If it isn’t available in the drop-down list and needs to be created, please contact the Merchant Service Desk via the Okta SSO page. | Mandatory |
| Frontend Name (EN), (ZH) | Product name displayed on the storefront in English and Chinese. e.g., Apple iPhone 15 |
Mandatory |
| Description Image (EN), (ZH) | Lifestyle images that appear next to the description. ❗ Dimensions: 1280px × 852px |
Optional |
| Description (EN), (ZH) | Product Description in English and Chinese. 📝 Food Products: Include the food guidelines at the bottom (e.g., “Product received will be at least 3 months from expiry”). |
Mandatory |
| Additional Description Image (EN), (ZH) | Lifestyle images that appear next to the Additional Description. ❗ Dimensions: 1280px × 852px |
Optional |
| Additional Description (EN), (ZH) | Provide an Additional Description to use this field. | Optional |
| Awards 1, 2, 3 | Upload award images. Images should be square. | Optional |
| Video Link 1, 2, 3 (EN), (ZH) | Input YouTube video links. ⚠️ Only YouTube links are accepted. |
Optional |
| Is Free Gift? | Select Yes if the product is a GWP (gift with purchase). | Optional |
| Travel Exclusive | Select Yes if the product is sold exclusively for travellers. | Optional |
| Love SG | Select Yes if the product is from a Singapore local brand. | Optional |
| Changi Exclusive | Select Yes if the product is sold exclusively in Changi and nowhere else. | Optional |
| Changi 1st | Select Yes if the product is first to launch or pre-launch in Changi (e.g., Worldwide / Asia / APAC / TR / TR APAC), has Changi-exclusive packaging/bundle, exclusive shade/colour/size, or has a Changi-exclusive GWP. | Optional |
| Changi1st Start Time | Start date of launch/exclusivity. Format: DD-MM-YYYY |
Optional |
| Changi1st End Time | End date of launch/exclusivity. Format: DD-MM-YYYY |
Optional |
| Gift And Value | Select Yes if the product is a gift set. | Optional |
| Variant Group Code | If the product has variants (e.g. different colours, storage capacities, or weights), you may group them as a single listing using a simple code (e.g. AppleiPhone15ProMax).
⚠️ Once the product has been created, the Variant Group Code cannot be edited. If you need to change the Variant Group Code, you will need to delete and re-create the product with the correct code. If you are adding a new variant product, you may use the same code to group it with the other variants. |
Optional |
| Backend Product Name (EN), (ZH) | Product name for backend reference in English and Chinese. If the product has variants, include the variant (e.g., Apple iPhone 15 – Midnight 256GB). | Mandatory |
| SKU Code | Company SKU code. For bundles, create a unique code. ⚠️ Limit of 16 characters. Do not use symbols, spaces, or an existing SKU code, or you may face issues during product creation. |
Mandatory |
| EAN | EAN/Bar Code Number. For bundles, create a unique code. ⚠️ Limit of 16 characters. Do not use symbols, spaces, or an existing EAN. |
Mandatory |
| Hero Image | Include an image URL or upload the main product image directly into TREX. 📝 See the Hero Image guidelines. |
Recommended |
| Image2 to Image20 | Include image URLs or upload directly into TREX. | Recommended |
| Swatch Image | Include an image URL for the product colour swatch. | Optional |
| Meta Description (EN), (ZH) | Brief description of the product’s USP in English and Chinese. ⚠️ Limit of 255 characters. |
Optional |
| Meta Keywords (EN), (ZH) | Keywords/phrases about the product, type, function, etc., in English and Chinese. 💡 Separate keywords with a comma. ⚠️ Limit of 255 characters. |
Optional |
| SEO Description (EN), (ZH) | Short SEO description of the product’s USP in English and Chinese. | Optional |
| Beverage Volume | 📝 Wine & Spirits: Input the volume. ⚠️ Numerical values only. |
Optional |
| Category Specific Attributes |
|
Optional |
| Variant Attributes e.g., Storage Capacity, Colour, Volume, Size, Weight |
Please include the variant information. In the template, search for level1saleMeasure and/or level2saleMeasure (if applicable). Include the code in the Variant Group Code field to group products. |
Optional |
| Image 1 to Image 5 (WeChat Mini-Programme Images) |
Input the image URLs (up to five). 💡 Dimensions: 710 × 1400 px (shorter images like 710 × 1000 px are acceptable). 📝 Image 1–5 will be joined into one vertical image on the WCMP PDP. |
Optional |
Unique Attributes
| Fields | What to Fill Up | Status |
|---|---|---|
| Retail Price | Selling price before discount and GST. ⚠️ If not absorbing GST, select False for the GST Absorption – Traveller and GST Absorption – Non-Traveller fields later. |
Mandatory |
| Stock Quantity | Quantity available for sale. | Mandatory |
| Out Of Stock Quantity | Product will appear as out of stock when the stock quantity hits this number. | Optional |
| Low Quantity Alert | Email notification will be sent when stock quantity hits this number. | Optional |
| Availability Start Date | Start date/time when the product becomes available on the storefront. Format: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss+00 |
Optional |
| Availability End Date | End date/time for storefront availability. 💡 To hide a product, input a past date (e.g., yesterday). Format: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss+00 |
Optional |
| Discount Price | Create Discount Price Promotions via the Marketing Centre. | Optional |
| Staff Discount Price | Create Staff Price Promotions via the Marketing Centre. | Optional |
| Offer SKU | Input the SKU code. 📝 Do not exceed 16 characters or include symbols other than a hyphen (-). ⚠️ Once the Offer SKU Code has been created in TREX, it cannot be amended or removed. You will need to delete the product listing if you wish to remove or change the code. |
Mandatory |
| Lead Time to Order (Travellers) | Minimum number of hours a traveller can purchase before flight. Off-Airport: Select 72 (unless specially arranged). In-Airport: Select the most appropriate option. |
Mandatory |
| Lead Time To Ship (Days) | For merchants on Dropship/ Merchant3PL: Days to pack before handing to your logistics partner. 💡 Added on top of delivery days shown on storefront. |
Optional |
| Shipment Type | Alternate shipment type for this SKU. Speak to your Account Manager to proceed (backend configuration required). | Optional |
| Airport Collection | If selling to Non-Travellers (NT) only, select None. Otherwise, choose the most appropriate option. 📝 Note: For the Both or Departure option, please be aware that the product packaging dimensions should not exceed 54cm x 36cm x 20cm to adhere to (key) airline restrictions. |
Mandatory |
| Home Delivery | If selling to Non-Travellers (NT) only, select HomeNonTraveller. | Mandatory |
| Jewel Collection | Select True to enable collection at Jewel. Speak to your Account Manager to proceed (backend configuration required). | Optional |
| GST Absorbed Traveller | (*For Arrival and Traveller – Home Delivery orders) Select accordingly. If GST Absorption – Non-Travellers is set to True (absorbed), GST will not be added at checkout. If set to False (not absorbed), GST will be calculated and added at checkout. |
Optional |
| GST Absorbed Non Traveller | Select accordingly. If GST Absorption – Non-Travellers is set to True (absorbed), GST will not be added at checkout. If set to False (not absorbed), GST will be calculated and added at checkout. |
Optional |
| Rental Department Code | Please speak to your Account Manager if special codes are required. | Mandatory |
| Locker Restricted | For merchants on CAG Consolidated fulfilment: Select True if the product is < 80cm (L×W×H) and < 5kg. | Mandatory |
| LAG Item | Select True if the SKU is a Liquid, Aerosol or Gel exceeding 100ml. 💡 LAG products must be packed in STEB bags during fulfilment. |
Optional |
| Airport Staff Only | Select True if the product is intended for Airport Staff only. | Optional |
| Duty Absorbed Traveller | Select False if not absorbing Duty for Travellers. | Optional |
| Duty Absorbed For Non Traveller | Select False if not absorbing Duty for Non-Travellers. | Optional |
| Duty Amount | Wine & Spirits (Travellers): Record the Excise Duty Amount for the product. | Optional |
Step 3: Uploading the filled product template
1. Products
2. My Products
3. Select Bulk Upload of Multiple Products
4. Drop the file in the Uploaded Templates section.
5. Click on Upload New Template.
6. Check on the Status section.
If there is a green tick, the file has been successfully uploaded.
If there is an exclamation mark, the file has errors.
8. If there are errors, please click on Download Error Report.
9. In the error report, scroll to the right. Refer to the error message under the Failed Reason column. In this example, the delivery type has been left empty for this product.
10. In the uploaded file, fix the error for the affect field/column. In this example, the delivery type will need a selection.
11. Proceed to re-upload the file and repeat the steps from Step 1 onwards.
What's Next
Once your products have been successfully created, the Seller Centre Team will review them for approval.
📝 Note: The standard service level agreement (SLA) for product approval is 1–2 business days.
If there are no issues, the product will be approved and its status will update from New ➡️ Approved.
If there are issues, the product will be temporarily rejected and a rejection reason will be provided. The product status will change from New ➡️ Changes Required.
💡 Upcoming product launch? You can request an expedited product approval via the Merchant Service Desk on the Okta SSO page.