How to mass create products
💡This is an example of the template that you will be using to create multiple products/skus.
Filled Template Examples
⚠️ The examples below are for reference only. Please download your own templates and fill up the information accordingly.
Beauty: 📄 Skincare Products (Grouped)
Wine & Spirits: 📄 Whisky Products
Electronics: 📄 Audio Products (Grouped)
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
- 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 an English translation (EN) and a Chinese translation (ZH). If the Chinese translation is not available, please copy the English translation over.
- Do not include external links in the Description and Additional Description fields.
| Fields | What to fill up | > | |
| Category | Select from the drop-down list. | Mandatory | |
| Brand | Type in the Brand. If not available, please inform the Seller Centre Team. | Mandatory | |
| Frontend Name (EN), (ZH) | Product Name displayed on the frontend in English (EN) and Chinese (ZH). E.g., Apple iPhone 15 | Mandatory | |
| Description Image (EN), (ZH) | Lifestyle images may be used. This will appear next to the Description. ❗Dimensions: 1280px by 852px |
Optional | |
| Description (EN), (ZH) | Product Description in English [en] and Chinese [zh]. 📝Food Products: Please include the Food Guidelines at the bottom e.g., Product received will be at least of 3 months from expiry date |
Mandatory | |
| Additional Description Image (EN), (ZH) | Lifestyle images may be used. Image will appear next to the Additional Description. ❗Dimensions: 1280px by 852px |
Optional | |
| Additional Description (EN), (ZH) | Provide an Additional Description Image to utilise this field | Optional | |
| Awards 1, 2, 3 | Image should be of squared dimensions. | Optional | |
| Video Link 1, 2, 3 (EN), (ZH) | Input YouTube video link. ⚠️ Only YouTube video links are accepted. |
Optional | |
| Is Free Gift? | Select Yes if product is a GWP | Optional | |
| Travel Exclusive | Select Yes if product is sold exclusively for Travellers only | Optional | |
| Love SG | Select Yes if product is from a local brand in Singapore | Optional | |
| Changi Exclusive | Select Yes if product is sold exclusively in Changi only and nowhere else in the world. | Optional | |
| Changi 1st | Select Yes if product is first to launch or pre-launch in Changi (E.g. Worldwide/ Asia/ APAC/ TR/ TR APAC), Changi exclusive packaging set or TR bundle set, Changi Exclusive shade/ colour/ size or has a Changi exclusive GWP. |
Optional | |
| Changi1st Start Time | Start date of launch and exclusivity. Format: DD-MM-YYYY |
Optional | |
| Changi1st End Time | End date of launch and exclusivity. Format: DD-MM-YYYY |
Optional | |
| Gift And Value | Select Yes if product is a Gift Set | Optional | |
| Variant Group Code | If the product has variants e.g. different colours, storage capacities, weight etc., you may group these products together as a single product listing with different options. Create a simple code e.g., AppleiPhone15ProMax ⚠️ Once the Variant Group 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 the code. |
Optional | |
| Backend Product Name (EN), (ZH) | Product Name for backend reference in English (EN) and in Chinese (ZH). If product has variants (different colours, sizes, etc.), please include the variant. e.g., Apple iPhone 15 – Midnight 256GB |
Mandatory | |
| SKU Code | Company SKU code. Bundle SKUs: Create a unique code. ⚠️ There is a limit of 16 characters. Please do not use symbols, spaces or the same code as an existing SKU or you may face issues during product creation. |
Mandatory | |
| EAN | EAN/ Bar Code Number. Bundle SKUs: Create a unique code. ⚠️ There is a limit of 16 characters. Please do not use symbols, spaces or the same code as an existing SKU or you may face issues during product creation. |
Mandatory | |
| Hero Image | Include an image URL or upload the main product image directly onto TREX. 📝 Note: Please check the Hero Image guidelines prior. |
Recommended | |
| Image2 to Image20 | Include an image URL or upload directly onto TREX | Recommended | |
| Swatch Image | Include an image URL of the product colour | Optional | |
| Meta Description (EN), (ZH) | Brief description of the product’s unique selling point in English (EN) and Chinese (ZH). ⚠️ Limit of 255 characters max. |
Optional | |
| Meta Keywords (EN), (ZH) | Keywords or phrases on the product, product type, function etc. in English (EN) and in Chinese (ZH). 💡Separate keywords or phrases with a comma. ⚠️ Limit of 255 characters max. |
Optional | |
| SEO Description (EN), (ZH) | For Search Engine Optimisation. Brief description of the product’s unique selling point in English (EN) and in Chinese (ZH). | Optional | |
| Beverage Volume | 📝 Wine & Spirits: Input the volume. ⚠️ Numerical values only. |
Optional |
Unique Attributes
| Fields | What to fill up | |
| (Variant Attributes) E.g., Storage Capacity, Colour, Volume, Size, Weight etc., |
You may find this field in the template by searching level1saleMeasure and/or level2saleMeasure (if applicable). Please fill up variant information if intending to group products together. Please note the Variant Group Code field will have to be filled up first.  |
Optional |
| Retail Price | Selling price before discount and GST. ⚠️ If not absorbing GST, select False for the GST Absorption fields later. |
Mandatory |
| Stock Quantity | Stock available for sale | Mandatory |
| Out Of Stock Quantity | Product will appear as out of stock (OOS) when the stock quantity hits this number. | Optional |
| Low Quantity Alert | Email notification will sent when stock quantity hits this number. | Optional |
| Availability Start Date | Start Date/ Time for the product to be available on storefront. Format: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss+00 |
Optional |
| Availability End Date | End Date/ Time for the product to be available on storefront. 💡 To hide a product from storefront, input a past date e.g., Yesterday’s date. Format: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss+00 |
Optional |
| Discount Price | Input the Discounted Price before GST. ⚠️ If not absorbing GST, select False for the GST Absorption fields later. |
Optional |
| Discount Start Date | When the Discount starts. Format: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss+00 |
Optional |
| Discount End Date | When the Discount ends. Format: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss+00 |
Optional |
| Staff Discount Price | Create Staff Price Promotions via the Marketing Centre. | Optional |
| Offer SKU | Input the SKU Code. 📝 Note: Do not exceed 16 characters or include symbols other than – |
Mandatory |
| Lead Time to Order (Travellers) | Minimum number of hours a Traveller can purchase a product before their flight. Off-Airport merchants: Select 72. (*Unless on a special arrangement) In-Airport Merchants: Select the most appropriate option. |
Mandatory |
| Lead Time To Ship (Days) | Merchant on Dropship Merchant3PL mode: Lead time to pack an order before handing it over to your logistics partner. 💡 This is added onto the # of delivery days on storefront. |
Optional |
| Shipment Type | Another shipment type for this SKU. Please speak to your Account Manager to proceed with this arrangement as this needs to be configured backend. | Optional |
| Airport Collection | If selling to Non-Travellers (NT) only, select None. Otherwise, select the most appropriate option. | Mandatory |
| Home Delivery | If selling to Non-Travellers (NT) only, select HomeNonTraveller | Mandatory |
| Jewel Collection | Select True to enable the product to be collected by customers at Jewel. Please speak to your Account Manager to proceed with this arrangement as this needs to be configured backend. |
Optional |
| GST Absorbed Traveller | Select False if not absorbing GST for Travellers. | Optional |
| GST Absorbed Non Traveller | Select False if not absorbing GST for Non-Travellers. | Optional |
| Rental Department Code | Please speak to your Account Manager if there are any special codes to input. | Mandatory |
| Locker Restricted | Merchants on the CAG Consolidated fulfillment mode: Select True if product is less than 80cm (Length x Width x Height) and is less than 5kg. | Mandatory |
| LAG Item | Select True if SKU is a Liquid, Aerosol or Gel product exceeding 100ml. 💡 LAG products need to be packed in STEB bags during order fulfillment |
Optional |
| Airport Staff Only | Select True if the product is meant 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 sold to Travelers. Record the Excise Duty Amount for the product. | Optional |
Category Attributes
- Beauty Category – Fill up e.g., Product Claim, Beauty Ingredients, How to Apply information.
- Wine & Spirits Category – Fill up e.g., Volume, Alcohol % information.
- Electronics Category – Fill up e.g., Warranty Type, Warranty Period, Technical Specifications information.
- Food Category – Fill up e.g., Food ingredients, Including the Food Guidelines information.
- Health Category – Fill up e.g., Weight, Supplement No. of Capsules information.
- Fashion Category – Fill up e.g., Colour, Size, Material/ Look After Me information.
Step 3: Uploading the filled product template
- Products ➡️ Add New Products ➡️ Bulk Upload of Multiple Products
- Scroll down to the Uploaded Templates section, drag and drop the template within the box with the dotted line ➡️ Upload New Template
- Please check on the status of the import in the Uploaded Templates section. If there is an error, please click on Download Error Report to check the error. Make the necessary edits in your original file and re-import the file.
⚠️ If you do not check the status of the import and if there was an error, there may be a risk of products not being created in TREX.
What's Next
Once the products have been successfully created, the Seller Centre Team will review the products for approval.
📝 Note: SLA is 1-2 business days for product approvals.
If there are no issues, the product will be approved and the product status will change from New ➡️ Approved.
If there are issues, the product will be temporarily rejected and the rejection reason will be provided. The product status will change from New ➡️ Changes Required.
💡Upcoming product launch? Request for an expedited product approval.