TREX - How to mass create products
- Generating a template
- Filling up the product information in the template
- Uploading the filled product template into TREX
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 |
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. ❗Limit: 16 characters without symbols or spaces. 📝 Bundle SKUs: Create a unique code. ⚠️ Do not use the same code as a single selling SKU as this will overwrite the data of the single selling SKU. |
Mandatory | |
| EAN | EAN/ Bar Code Number. ❗Limit: 16 characters without symbols or spaces. 📝 Bundle SKUs: Create a unique code. ⚠️ Do not use the same code as a single selling SKU as this will overwrite the data of the single selling SKU. |
Mandatory | |
| Hero Image | Include an image URL or upload the main product image directly onto TREX ❗Check the Hero Image guidelines |
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). ❗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. ❗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 | |
| Retail Price | Selling price before discount and GST ❗If not absorbing GST, select No for the GST Absorbed 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 | Discounted price before GST. ❗If not absorbing GST, select No for the GST Absorbed 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 | Staff Price for Airport Staff before GST. Format: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss+00 |
Optional |
| Staff Discount Start Date | When the Staff Discount starts. Format: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss+00 |
Optional |
| Staff Discount End Date | When the Staff Discount ends. Format: YYYY-MM-DD or YYYY-MM-DDThh:mm:ss+00 |
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 💄. To fill up e.g., Product Claim, Beauty Ingredients, How to Apply .etc
- Wine & Spirits Category 🍾. To fill up e.g., Volume, Alcohol % .etc
- Electronics Category 🎧. To fill up e.g., Warranty Type, Warranty Period, Technical Specifications .etc
- Food Category 🍫. To fill up e.g., Food ingredients, Including the Food Guidelines
- Health Category 🧘. To fill up e.g., Weight, Supplement No. of Capsules
- Fashion Category 🧥. To fill up e.g., Colour, Size, Material/ Look After Me
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 to check the error. Make the necessary edits and try to re-import the file.
