Use Importer to manage and configure this feature in your EQuipWeb system.

Use the Supplier Product Importer to link many products to their suppliers at once. Instead of assigning suppliers to products one by one, prepare the mappings in a spreadsheet and upload them here.

When to use this: When you need to link supplier product codes and costs to your products in bulk.

Prerequisites

• User must have appropriate role permissions (see Access & Permissions above)

Supplier Product Importer

📝 General Description

This importer creates or updates the link between products and their suppliers. Each row defines which supplier provides which product, at what cost, and under what supplier-specific product code. This information streamlines Purchase Order creation — when you select a supplier, the system knows which products they supply and at what cost.

---

Use Importer to manage and configure this feature in your EQuipWeb system.

10.5.1 Template Columns

Sample Template

---

Use Importer to manage and configure this feature in your EQuipWeb system.

10.5.2 How to Import Supplier-Product Mappings

1. Navigate to Data Importer → Supplier Product Importer.

2. Click Download Template to get the CSV template.

3. Open in Excel and fill in the mappings.

4. Ensure SupplierName exactly matches suppliers configured in Supplier Setup (Section 8.8). 5. Save as CSV. 6. Click Browse → Select your CSV file.

7. Click Upload to process.

8. Review results:
   • ✅ Created: New supplier-product links created.
   • 🔄 Updated: Existing links updated (cost price, lead time, etc.).
   • ❌ Error: Invalid ItemNo or SupplierName.

---

Use Importer to manage and configure this feature in your EQuipWeb system.

10.5.3 Validation Rules

---

Use Importer to manage and configure this feature in your EQuipWeb system.

10.5.4 Multi-Supplier Support

One product can have multiple suppliers with different costs:

When creating a Purchase Order:

• The system defaults to the preferred supplier's cost price.
• You can manually switch to an alternative supplier if needed (e.g., urgent order with faster delivery).

---

Use Importer to manage and configure this feature in your EQuipWeb system.

💡 Example

Scenario: A retailer sources 300 products from 5 different suppliers and needs to map them all.

Steps:

1. Create all 5 suppliers in Supplier Setup (Section 8.8) first.
2. Prepare the CSV template with all 300 product-supplier mappings, including cost prices.
3. Mark the primary supplier for each product as IsPreferred = Y.
4. Import via Supplier Product Importer.
5. Now when creating Purchase Orders, the system auto-fills cost prices for each supplier's products.

[!TIP] Keep CostPrice values up-to-date by re-importing periodically when suppliers update their pricing. This ensures Purchase Orders always use the latest costs.

[!IMPORTANT] The SupplierName must exactly match the supplier record (case-sensitive). If "ABC Trading Pte Ltd" is in the system, don't use "ABC Trading" in the CSV — it won't match.

---

Use Importer to manage and configure this feature in your EQuipWeb system.

Access & Permissions

[!NOTE] Exact permissions depend on the Privileges Setup configured for each role. Contact your administrator if you cannot access this page.

---

Use Importer to manage and configure this feature in your EQuipWeb system.

How to Import Data

1. Navigate to Data Importer & Exporter → Supplier Product Importer from the sidebar menu.

2. Click Download Template to get the Excel template with correct column headers.

3. Open the template and fill in your data according to the column headers.

4. Save the completed Excel file.
5. Click Choose File and select your completed template.
6. Click Import to upload and process the file.
7. Review the validation results — fix any errors and re-upload if needed.
8. Click Confirm Import to finalize.

✅ Expected Result: Data is imported and available in the system.

---

FAQ

Q: What file format should I use for import? A: Use .xlsx (Excel) format. Download the blank template from the importer page to ensure correct column structure.

Q: Can I undo an import? A: No. Imports cannot be automatically reversed. You would need to manually correct or delete the imported records.

Q: Why does my import show validation errors? A: Check the error details for each row. Common issues include: missing required fields, duplicate codes, invalid date formats, or referencing categories/departments that don't exist yet.

---

Use Importer to manage and configure this feature in your EQuipWeb system.

Troubleshooting

---

Use Importer to manage and configure this feature in your EQuipWeb system.

Related Menus

• Product Setup > Product List — imported product destination
• Membership Setup > Membership List — imported member destination
• Master Data > Supplier Setup — supplier data reference

---

Use Importer to manage and configure this feature in your EQuipWeb system.

Open Questions / Confirmation Needed

[!NOTE] The following items may vary depending on your system version and configuration:

• Exact permission settings depend on your Privileges Setup configuration
• Sync timing to POS terminals depends on network conditions and sync schedule
• Some features may require additional licensing or module activation
• Field behavior may differ between EQuip versions

If you encounter behavior not described in this manual, contact your system administrator or EQuip support team.

Expected Result: Changes are saved successfully and reflected across the system after the next POS sync.

---

Field Reference

[!NOTE] Additional fields specific to this page are documented in the sections above. The table above shows common fields present across most pages.