Purpose

Products in E-Retail can be created in two ways:

• Product Master – for creating and maintaining products individually.

• Product Loader – for importing multiple products in bulk using an Excel template.

Both methods ensure product records are accurately set up with hierarchy, vendor, attributes, and pricing, which supports purchasing, sales, inventory tracking, and marketplace integration.

Prerequisites (for both methods)

Before creating products, the following pre-setup must be completed:

1. Product Hierarchy Setup (Level 1–4) – Master Setup > Product Setup > Product Hierarchy Setup

2. Colour Setup – Master Setup > Product Setup > Colour Setup

3. Size Setup – Master Setup > Product Setup > Size Setup > Size Setup

4. Size Group Setup – Master Setup > Product Setup > Size Setup > Size Group Setup

5. Vendor Setup – Master Setup > Vendor Setup > Vendor Setup

6. (Optional) Product Attribute Setup – Master Setup > Product Setup > Attribute Setup > Product Attribute Setup
   

7. (Optional) Product Detail Setup – Master Setup > Product Setup > Attribute Setup > Product Detail Setup

8. (Optional) Buyer Setup – Master Setup > Master Setup > Buyer Setup

Option 1 – Creating Products via Product Master (Manual Entry) 

Step 1 – General Information (Top Panel)

1. Go to Master Setup > Product Setup > Product Master.

2. Click New.

3. Select Product Hierarchy Levels 1–4 using the 3-dotted button.

4. Input or auto-generate Product Code.

5. Enter Short Name.

6. Enter Description (full product name).

7. Select Tax % using the 3-dotted button.

8. (Optional) Select Buyer (only available if Buyer Setup is pre-configured).

9. (Optional) Enter Alt Code 2 (normally used to record old product codes).

10. Select Vendor from the 3-dotted button.

11. (Optional) Leave Direct Store Delivery = Yes (default).

12. (Optional) Leave Product Type = Normal (unless it is Consignment or Concessionaire).

13. (Optional) Select Stocked Item:

    • Stocked (Default) = Countable in inventory (sales, refunds, transfers).

    • Stockless = Not tracked (e.g., services, delivery charges, paper bags, free gifts).

14. (Optional) Set Hard Launch:

    • Default = No (item sellable immediately in E-POS).

    • If Yes, select a Launch Date when the item becomes sellable.

15. (Optional) Enter Note.

16. (Optional) Tick Allow Online Selling if item will be listed in marketplaces via E-Omni.

17. (Optional) Set Status: Active (default), Inactive, or Discontinue.

Step 2 – Define Variants (Middle Section)

1. Select Colour Codes via the 3-dotted button.

2. Select Size Group via the 3-dotted button.

3. Select Sizes via the 3-dotted button.

   •  This creates product variants across Colour/Size combinations into SKUs.

Step 3 – Price Tab (Bottom Section)

1. Enter Purchase Cost.

   • Converted automatically into SGD if vendor uses foreign currency.

2. Enter Retail Price:

   • Input 0 → cashier prompted for manual price entry at E-POS.

   • Tick Zero Price Item → always treated as zero price (no prompt).

Step 4 – SKU Tab (Bottom Section)

For each variant, maintain the following:

• SKU Code – Manual if not auto-generated (max 20 chars).

• (View) POS Code – Auto-generated (8 digits).

• (Optional) EAN Code – Barcode reference (max 20 chars).

• (View) Orig Retail Price – First retail price set.

• Retail Price – Current selling price.

• (Optional) Recommended Price – Reference for alternative pricing.

• (View) Orig Purchase Cost – First purchase cost set.

• Purchase Cost – Current purchase cost.

• (Optional) Average Cost – For refreshed margin/COGS calculation from the point of update

• (Optional) Direct Cost – Foreign currency cost used in Purchase Orders.

• (Optional) Wholesale Price – For Wholesale/B2B selling price.

• (Optional) None Stock – Defines SKU as Stocked or Stockless items down to SKU level.

• (Optional) UPC Code – Extended barcode if applicable (max 20 chars)

• (Optional) SKU Notes – Optional notes per SKU

Reminder: Any of SKU Code, POS Code, EAN Code, or UPC Code scanned in E-POS/M-POS will point to the same product.

Step 5 – (Optional) Attribute Tab (Bottom Section)

• Assign Product Attributes by selecting Attribute Types and Codes from the 3-dotted button list.

Step 6 – (Optional) Country Price Tab (Bottom Section)

• Input different retail prices if the company operates in multiple countries under the same E-Retail database.

Step 7 – (Optional) Alternate Vendors Tab (Bottom Section)

• Add additional vendors if the product can be sourced from more than one vendor.

• This impacts:

  • Vendor selection in Purchase Orders.

  • Pre-set vendor addresses linked to the product.

Step 8 – (Optional) Extended Notes Tab (Bottom Section)

• Enter additional information in Note 1, Note 2, Note 3 at the product level.

Step 9 – (Recommended) Image Tab (Bottom Section)

• Upload product images according to Colour Variants.

Step 10 – (Optional) Online Stores Tab (Bottom Section)

• Record the marketplaces where this product is sold (via E-Omni integration).

Step 11 – Info Tab (Bottom Section)

• View product metadata:

  • Created Date

  • Last Updated Date

  • Last Updated By

Step 12 – Save, Confirm & Search

1. Click Save to save the product as draft.

2. Use the 3-dotted button or the Search section to:

   • Edit → update details of a draft product.

   • Confirm → finalize the product record.

   • Cancel → discard if no changes required.

   • Close → exit the module.

3. After confirmation, users can go to Master Setup > Product Setup > Product Inquiry to search and view created products in the future.

4. For immediate effect in E-POS, perform Sync on E-Manager and E-POS. Otherwise, the update will only reflect on the next scheduled sync.

Option 2 – Creating Products via Product Loader (Bulk Import)

Step 1 – Access Product Loader

• Go to Master Setup > Date Loader > Product Loader.

• Click Download Template.

Step 2 – Populate Template

Fill in Excel columns:

1. Product Code (20 characters)

2. SKU Code (20 characters )

3. EAN Code (20 characters) – Optional

4. Alt Code 2 (20 characters) – Optional

5. Product Name (50 characters)

6. Short Name (20 characters)

7. Level 1–4 Code (2 characters each)

8. Colour Code (3 characters)

9. Size Group Code (3 characters)

10. Size Code (3 characters)

11. Supplier No. (10 characters)

12. Tax Code (10 characters) – Default value to input: TAX

13. Cost Price (2 decimal places)

14. Retail Price (2 decimal places)

15. Buyer Name (30 characters) – Optional

16. Product Type (1=Standard [default if leave blank], 2=Concessionaire, 3=Consignment) - Optional

17. Stock Item Type (1=Stocked [default if leave blank] , 2=Not allowed, 3=Stockless)  - Optional

18. Direct Store Delivery (Y [default if leave blank], N) - Optional 

19. Hard Launch (Y [default if leave blank], N) - Optional 

20. UPC Codes 1 – 8 (20 characters each) – Optional

21. Allow Online Selling (Y/N) – Optional

22. Colour Description 1–2 (100 characters each) – Optional

23. Weight (KG) (2 decimal places) – Optional

24. Attribute 1 – 8 (8 codes) – Optional

Step 3 – Import Template

• Import the Excel file.

• Module shows Total Lines, Succeeded, Failed.

Step 4 – Fix Import Errors

• Errors are highlighted in red with messages.

• Export:

  • Export Fail Data (only failed lines).

  • Export All Data (both succeeded & failed).

• Correct and re-import until all succeed.

Step 5 – Confirm Import

• Once no failed lines, click Confirm.

• Products are created in the system.

Step 6 – (Optional) Import Images via Product Image Loader

1. Go to Master Setup > Data Loader > Product Image Loader.

2. In Image Folder Path, click 3-dotted button to select the folder where images are stored.

3. In Image Type, choose JPG, JPEG, or BMP.

4. File naming rules:

   • Default = <Product Code>

   • Colour checkbox has to be checked, and it will turn on the import format and it must be:
     <Product Code> + <- / _ / . / space> + <Colour Short Name / Colour Description / Colour Code>

     • Example: TSHIRT001-RED or TSHIRT001_RED or TSHIRT001.RED or TSHIRT001 RED

5. Click Import to import images

6. System shows Total, Succeeded, Failed.

7. Click Export Fail Data or Export Success Data to download the data to review results.

8. Fix naming or file type errors and re-import.

9. Once all succeed, click Confirm to link images to products.

Notes / Tips

• Use Product Master for one-off or detailed product creation.

• Use Product Loader for mass product onboarding.

• Product Loader requires the same pre-setup dependencies as Product Master.

• Complete all pre-setups (hierarchy, size, colour, attributes, vendors, buyer) before starting Product Master/Product Loader.

• Alt Code 2 is best used for legacy product codes for reference.

• Use Zero Price Item only for free gifts or zero-value merchandise.

• Alternate Vendors setup ensures smoother PO creation when multiple suppliers provide the same product.

• Uploading images improves product recognition by EPOS/MPOS users.

• Perform sync to E-Manager & E-POS for immediate effect or otherwise it will only take effect on the next day.

• Product Master module: Always Confirm products after setup — drafts are not active until confirmed

• Product Loader module: Start with fresh templates to avoid Excel formatting issues.