Products are created on upload or updated if the key field (ProductCode) already exists in Sage.
The Configuration tab allows you to chose to overwrite or ignore blank fields.
Field Mapping (mandatory fields in RED)
E2S Field |
SAGE Field |
Location within Sage |
Length |
Notes |
ProductCode |
Product Code |
Product Record - Product Details |
30 |
The key field for this tab. If this code is already in Sage the other fields on the xls are updated |
Description |
Description |
Product Record - Product Details |
60 |
|
DefSalesNomCode |
Sales Nominal Code |
Product Record - Defaults |
8 |
|
DefPurNomCode |
Purchase Nominal Code |
Product Record - Defaults |
8 |
|
DefTaxCode |
Tax Code |
Product Record - Defaults |
2 |
|
DefSupplier |
Supplier A/C |
Product Record - Defaults |
8 |
|
UnitOfSale |
Unit Of Sale |
Product Record - Sales Price |
8 |
|
SalesPrice |
Price |
Product Record - Sales Price |
8 |
|
LastPurchasePrice |
Last Cost Price (Standard) |
Product Record - Ordering |
8 |
|
Location |
Location |
Product Record - Product Details |
16 |
|
CustomA |
Category A |
Product Record - Web - Custom Fields |
60 |
|
CustomB |
Category B |
Product Record - Web - Custom Fields |
60 |
|
CustomC |
Category C |
Product Record - Web - Custom Fields |
60 |
|
ROL |
Re-order Level |
Product Record - Status |
8 |
|
ROQ |
Re-order Quantity |
Product Record - Status |
8 |
|
Barcode |
Bar Code |
Product Record - Product Details |
60 |
Sage 50 v2011 onwards only |
IntraStatComCode |
IntraStat Com. Code |
Product Record - Product Details |
8 |
|
ComCode |
Com. Code Description |
Product Record - Product Details |
8 |
|
PartNo |
Part No. |
Product Record - Defaults |
16 |
|
Weight |
Weight (kg) |
Product Record - Product Details |
8 |
|
Category |
Category |
Product Record - Product Details |
2 |
|
ItemType |
Item Type |
Product Record - Product Details |
1 |
0= Stock, 1 = Non-stock, 2 = Service |
Dept |
Department |
Product Record - Product Details |
2 |
|
WebDescription |
Description |
Product Record - Web - Web Defaults |
60 |
|
WebDetails |
Details |
Product Record - Web - Web Defaults |
1023 |
|
WebPublish |
Publish to Web |
Product Record - Web - Web Defaults |
3 |
Yes/No |
WebSpecialOffer |
Special Offer |
Product Record - Web - Web Defaults |
3 |
Yes/No |
WebImage |
image |
Product Record - Web - Image |
60 |
The file must exist in your Sage company images folder |
ComponentCode1-20 |
Product Code |
Product Record - Bill of Materials |
30 |
|
ComponentQty1-20 |
Quantity |
Product Record - Bill of Materials |
8 |
|
DiscountALevel1-10Qty |
Quantity |
Product Record - Discount |
8 |
|
DiscountALevel1-10Rate |
Discount % |
Product Record - Discount |
8 |
|
DiscountBLevel1-10Qty |
Quantity |
Product Record - Discount |
8 |
|
DiscountBLevel1-10Rate |
Discount % |
Product Record - Discount |
8 |
|
DiscountCLevel1-10Qty |
Quantity |
Product Record - Discount |
8 |
|
DiscountCLevel1-10Rate |
Discount % |
Product Record - Discount |
8 |
|
DiscountDLevel1-10Qty |
Quantity |
Product Record - Discount |
8 |
|
DiscountDLevel1-10Rate |
Discount % |
Product Record - Discount |
8 |
|
DiscountELevel1-10Qty |
Quantity |
Product Record - Discount |
8 |
|
DiscountELevel1-10Rate |
Discount % |
Product Record - Discount |
8 |
|