Product

/ /

Releated Topics.

Filter Extracted Data
Training on Static Data
Product Category
Bill of Materials
Price Lists

Save time updating

Sage 50

Stock/Product Creation
Customer/Supplier Prices
Bill of Material
Project Creation
Location Bins

Sage 200

Simply extract, edit and import

Xero

Import from Excel

50 Trans

Nominal Journals
Quotes/Invoices/Orders
Remote Orders
Product/Stock Adjustments
Sales Receipts
Quick OrderPad

200 Trans

Transaction from Manual Input

Multiple Transactions from CSV file

Xero

Solve the Puzzle?

Sage 50

Help on every type of import
Demo Video of all functionality
Loads of Examples included
Online Training
We can help too…

Sage 200

Xero

Great Customer Satisfaction

Customer Comments

Full Trial with Demo Data
Low cost Subscription
Cancel anytime
From a £1 a day
Saving you hours

Simply extract, edit and import

Power of Excel

Sage 50

Quick Template Creation
Customise with:
    Formula
    Macros
    VBA

Sage 200

To reach your goals quickly

Sage 200

Sage 200 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Manufacturing

200 Manufact.

Create BOM Stock Easily
Create Bill of Materials
Labour, Machine, Tools

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

50 Projects

..u.

Sage 50:Extract/Amend/Import Products

PostTrans imports Products, which could be manually entered with the assistance of in-cell searching, using copy and paste, imported from CSV file or extracted from Sage 50 using the Extract button.

Page Contents

Stock Import in Sage 200

Product Import Example
Demo Videos
Template Structure in detail
Common Features
Template Tags
Related Example Templates included with PostTrans

Import Product Features in Sage 50

Simply add new lines to the spreadsheet from row 30 on-wards. Then press Import button, on the PostTrans Toolbar, to import single or multiple Products (Examples shown below).

Advantages

Highlighted Validation of codes and data
Search for Related Account, Stock, Project, Nominal, using our In-Cell Searching
Add formula, vba or macros to manipulate the imported data
Press Extract to populate the sheet with existing data, amend and Import
Easy importation from CSV file

Examples of importing Sage 50 Products

Product Import template for importing into Sage 50

Demonstration Video

Sage 50 - Import Product/Stock Data, also Extract and Edit

	0:00	Video Introduction
	1:00	Create Product/Stock Template
	3:30	Extract Product/Stock data from Sage Line 50
	5:00	Copy stock items
	7:00	Alter Template to edit Product Web Information
	8:00	Import Product/Stock back into Sage Line 50
	10:35	How to find more information and Training

To use the template, with Sage 50, install PostTrans. Download
Trial with Sage demo company. Purchase a month subscription for Live Sage Company. Price
Watch the On-line Training course on how to use and customise the templates.

Template Structure for Static Data

The template must have tag ‘Sage50prod’ in cell A1 to instruct PostTrans that we are interested in Sage 50 Products, and that the sheet is a PostTrans Template. Pressing Import or Extract on a blank sheet will either open an existing example or create basic template for you to customise.

Row 1 contains a series of tags, which denote to PostTrans the data to be read/written in each column. These tags, and data columns can be rearranged to suit your needs, and the tags are added using the Tags button. See on-line Training Deleting the Tag name, in the cell, from this row removes the Sage 50 mapping. Table of Products Tags

Hovering over these tags, in row 1, will show a comment which explains the tags purpose, data type and any other useful details.

Common Features

In-Cell Searching

Any Tag ending with ^ with have a in-cell search facility to look up associated values. Use SPACE + TAB to see all values, or SPACE and TEXT to perform a text search on description. These are returned to the cell as "CODE, DESCRIPTION". PostTrans only uses the CODE and ignores the comma and anything after it, thus data from a field would only need the CODE part of the data if from an external imported file.

In-cell Searching can be turned off by removing the ^ from the end of the tag name, or name in first line of comment (Header cells) to disable in-cell searching for a single column, or header cell. All in-cell searching can be turned off in Setup. In-cell searching.

Extracting the Data

The data extracted using the Extract button can be filtered, by entering criteria in row 2. Hover over cell A2 for instructions. Extracting Data

Amending Products Data

Having extracted data, the user can now simply edit the Products in Microsoft Excel, before re-importing it back into Sage 50.

PostTrans uses the tagged column PrCRC to detect changes in rows. Therefore, only records/rows which have changed since extraction are updated. If you add or delete a tagged column, PostTrans will treat ALL rows as having changed, and thus ALL records will be updated on next Import.

Importing the Data

Simply press the Import button to validate and import the data into Sage 50. PostTrans will read the Header cells and then process the rows of data until PrCode column contains no data. The Sage Company imported into can be set in the Setup window.

PostTrans ONLY edits those fields listed on the sheet when importing, thus any existing values, on a record, are unaffected. New records may have default values for certain fields.

File Import Button

This can be enabled in Setup to easily import cvs, or fixed length files, into sheet for importation. Formula can also be added, or macros/VBA to manipulate this data before importation. Import from CSV file.

Validation

Any values and associated codes will be invalid during import. The cursor will be moved to highlight any problems in data.

Evaluation and License

This functionality will work with Sage Demo data without a license. A license is required to import into any other Sage Company. Pricing

What else can I do?

Other Sage 50 Extract/Import types

Frequently Asked Questions?

Got another question? It may well be covered on our Frequently Asked Questions page.

PostTrans Tags which map to Sage 50

Not all these tags/columns are needed. The table below lists the required and recommended:

Tag Name	Data Type	Description
Important Fields:
Sage50prod	Text Req	Returns `POSTED` if Trans line has been posted and will be ignored if `POSTED` (required). Also reports errors/warnings in data row
PrCRC	Text Req	Contains CRC number to help PostTrans detect changes in current row.
PrDelete	Text 1	This cell is very important, as it allows PostTrans to let you know of any errors or warnings while importing. If data is extracted out of the system, then it will contain a number. This number is calculated so PostTrans can work out if you have changed
PrSearch^	Text 30	Search for record by entering code or pasting list, at top of column, and pressing `Extract` button In Cell Searching values in table ProdCode
PrCode	Text 30 EOF Req XML	Stock Code
PrType^	Text 1 XML	Item Type In Cell Searching values:Stock Type 0, Stock 1, NonStock 2, Service
PrDesc	Text 60 XML	Description (120 chars in 2023 onwards)
PrCategory^	Integer XML	Stock Category Number In Cell Searching values in table ProdCatCode
Product Details:
PrCountryOrigin^	Text 2 XML	Country code of origin. Irish data sets only. Sage V21 2015 onwards In Cell Searching values in table CountryCode
PrComCodeDesc	Text 30 XML	Com. Code Description Sage V21 2015 onwards
PrIntrastatComCode	Text 8 XML	Intrastat Commodity Code Sage V20 2014 onwards
PrIntrastatImportDutyCode	Text 8 XML	Intrastat Import Duty code Sage V20 2014 onwards
PrSuppUnitQty	Double XML	Supplementary Unit Quantity Sage V20 2014 onwards
PrWeight	Double XML	Unit of Weight
PrBarCode	Text 60 XML	BarCode
PrInactive	Yes/No- XML	Inactive Flag - yes/No Sage V21 2015 onwards
PrLocation	Text 16 XML	Location
Defaults:
PrSalesNom^	Text 8 XML	Nominal Code In Cell Searching values in table NomCode
PrTaxCode^	Integer XML	Tax Code (0 to 99) In Cell Searching values in table TaxCode
PrPurchaseNom^	Text 8 XML	Purchase Nominal Code In Cell Searching values in table NomCode
PrPartNo	Text 16 XML	Supplier`s Part Number
PrSuppAccount^	Text 8 XML	Supplier`s Account Reference In Cell Searching values in table SupplierCode
PrDept^	Integer XML	Department No In Cell Searching values in table DeptCode
Ordering:
PrLastPurPrice	Currency XML	Last Purchase Price
PrLastCostDisc	Currency XML	Last Cost Discounted Price
PrLastCost	Currency XML	Last Cost Price
PrLastOrdQty	Double Read	Last Order Quantity
PrLastOrdDate	Date Read	Last Purchase Date
Sales Price:
PrSalesPrice	Currency XML	Sale Price
PrUnitOfSale	Text 8 XML	Unit of Sale
Status:
PrQtyInStoc	Double Read	Quantity In Stock
PrNewInStk	Text 20 Pro	New IN Stock figure. Used to perform a stock take, after updating Product Record adjust Qty IN to this value. Blanks ignored How use this tag for Stock Take
PrQtyAlloc	Double Read	Quantity Allocated
PrFree	Double Read	Free Stock
PrQtyOnOrder	Double Read	Quantity On Order
PrQtyReorderLevel	Double	Reorder Level
PrQtyReorder	Double	Reorder Quantity
Stock Take:
PrStockTakeDate	Date	Stock Take Date
PrStockTakeQty	Double	Last Stock Take Quantity
Web:
PrWebDescription	Text 60 XML	Web Description
PrWebLongDesc	Text 1023 XML	Web Long Description
PrWebPublish	Yes/No- XML	Web Publish Flag
PrWebSpecialOffer	Yes/No- XML	Web Special Offer
PrWebImage	Text 60 XML	Web Image Filename of the image which should be copied to the \ACCDATA\IMAGES sub folder of your data
Custom Fields:
PrCust1	Text 60 XML	Custom Field 1
PrCust2	Text 60 XML	Custom Field 2
PrCust3	Text 60 XML	Custom Field 3
Memo:
PrMemo	Memo Chg XML	Stock Record Memo
Cost:
PrCostLA	Currency Read	Brought Forward Costs
PrCostMon1	Currency	Month 1 Costs
PrCostMon2	Currency	Month 2 Costs
PrCostMon3	Currency	Month 3 Costs
PrCostMon4	Currency	Month 4 Costs
PrCostMon5	Currency	Month 5 Costs
PrCostMon6	Currency	Month 6 Costs
PrCostMon7	Currency	Month 7 Costs
PrCostMon8	Currency	Month 8 Costs
PrCostMon9	Currency	Month 9 Costs
PrCostMon10	Currency	Month 10 Costs
PrCostMon11	Currency	Month 11 Costs
PrCostMon12	Currency	Month 12 Costs
PrCostMonFuture	Currency	Future Costs
Cost Previous Year:
PrPriYrCostLA	Currency	Prior Cost Brought Forward
PrPriYrCostMon1	Currency	Prior Year Month 1 Costs
PrPriYrCostMon2	Currency	Prior Year Month 2 Costs
PrPriYrCostMon3	Currency	Prior Year Month 3 Costs
PrPriYrCostMon4	Currency	Prior Year Month 4 Costs
PrPriYrCostMon5	Currency	Prior Year Month 5 Costs
PrPriYrCostMon6	Currency	Prior Year Month 6 Costs
PrPriYrCostMon7	Currency	Prior Year Month 7 Costs
PrPriYrCostMon8	Currency	Prior Year Month 8 Costs
PrPriYrCostMon9	Currency	Prior Year Month 9 Costs
PrPriYrCostMon10	Currency	Prior Year Month 10 Costs
PrPriYrCostMon11	Currency	Prior Year Month 11 Costs
PrPriYrCostMon12	Currency	Prior Year Month 12 Costs
PrPriYrCostFuture	Currency	Prior Year Future Costs
Sales:
PrSalesLA	Currency Read	Sale brought Forward
PrSalesMon1	Currency	Month 1 Sales
PrSalesMon2	Currency	Month 2 Sales
PrSalesMon3	Currency	Month 3 Sales
PrSalesMon4	Currency	Month 4 Sales
PrSalesMon5	Currency	Month 5 Sales
PrSalesMon6	Currency	Month 6 Sales
PrSalesMon7	Currency	Month 7 Sales
PrSalesMon8	Currency	Month 8 Sales
PrSalesMon9	Currency	Month 9 Sales
PrSalesMon10	Currency	Month 10 Sales
PrSalesMon11	Currency	Month 11 Sales
PrSalesMon12	Currency	Month 12 Sales
PrSalesMonFuture	Currency	Future Sales
Budget Sales:
PrBudegtSalesLA	Currency Read	Brought Forward Budget Sales
PrBudegtSalesMon1	Currency	Month 1 Budget Sales
PrBudegtSalesMon2	Currency	Month 2 Budget Sales
PrBudegtSalesMon3	Currency	Month 3 Budget Sales
PrBudegtSalesMon4	Currency	Month 4 Budget Sales
PrBudegtSalesMon5	Currency	Month 5 Budget Sales
PrBudegtSalesMon6	Currency	Month 6 Budget Sales
PrBudegtSalesMon7	Currency	Month 7 Budget Sales
PrBudegtSalesMon8	Currency	Month 8 Budget Sales
PrBudegtSalesMon9	Currency	Month 9 Budget Sales
PrBudegtSalesMon10	Currency	Month 10 Budget Sales
PrBudegtSalesMon11	Currency	Month 11 Budget Sales
PrBudegtSalesMon12	Currency	Month 12 Budget Sales
PrBudegtSalesFuture	Currency	Future Budget Sales
Sales Privious Year:
PrPriYrSalesLA	Currency Read	Prior Year brought Forward
PrPriYrSalesMon1	Currency	Prior Year Month 1 Sales
PrPriYrSalesMon2	Currency	Prior Year Month 2 Sales
PrPriYrSalesMon3	Currency	Prior Year Month 3 Sales
PrPriYrSalesMon4	Currency	Prior Year Month 4 Sales
PrPriYrSalesMon5	Currency	Prior Year Month 5 Sales
PrPriYrSalesMon6	Currency	Prior Year Month 6 Sales
PrPriYrSalesMon7	Currency	Prior Year Month 7 Sales
PrPriYrSalesMon8	Currency	Prior Year Month 8 Sales
PrPriYrSalesMon9	Currency	Prior Year Month 9 Sales
PrPriYrSalesMon10	Currency	Prior Year Month 10 Sales
PrPriYrSalesMon11	Currency	Prior Year Month 11 Sales
PrPriYrSalesMon12	Currency	Prior Year Month 12 Sales
PrPriYrSalesFuture	Currency	Prior Year Future Sales
Qty Sold:
PrQtySoldLA	Double Read	Brought Forward Quantity Sold
PrQtySoldMon1	Double	Month 1 Quantity Sold
PrQtySoldMon2	Double	Month 2 Quantity Sold
PrQtySoldMon3	Double	Month 3 Quantity Sold
PrQtySoldMon4	Double	Month 4 Quantity Sold
PrQtySoldMon5	Double	Month 5 Quantity Sold
PrQtySoldMon6	Double	Month 6 Quantity Sold
PrQtySoldMon7	Double	Month 7 Quantity Sold
PrQtySoldMon8	Double	Month 8 Quantity Sold
PrQtySoldMon9	Double	Month 9 Quantity Sold
PrQtySoldMon10	Double	Month 10 Quantity Sold
PrQtySoldMon11	Double	Month 11 Quantity Sold
PrQtySoldMon12	Double	Month 12 Quantity Sold
PrQtySoldMonFuture	Double	Month 12 Quantity Sold
Budget Qty Sold:
PrBudgetQtySoldLA	Double Read	Brought Forward Budget Quantity Sold
PrBudgetQtySoldMon1	Double	Month 1 Budget Quantity Sold
PrBudgetQtySoldMon2	Double	Month 2 Budget Quantity Sold
PrBudgetQtySoldMon3	Double	Month 3 Budget Quantity Sold
PrBudgetQtySoldMon4	Double	Month 4 Budget Quantity Sold
PrBudgetQtySoldMon5	Double	Month 5 Budget Quantity Sold
PrBudgetQtySoldMon6	Double	Month 6 Budget Quantity Sold
PrBudgetQtySoldMon7	Double	Month 7 Budget Quantity Sold
PrBudgetQtySoldMon8	Double	Month 8 Budget Quantity Sold
PrBudgetQtySoldMon9	Double	Month 9 Budget Quantity Sold
PrBudgetQtySoldMon10	Double	Month 10 Budget Quantity Sold
PrBudgetQtySoldMon11	Double	Month 11 Budget Quantity Sold
PrBudgetQtySoldMon12	Double	Month 12 Budget Quantity Sold
PrBudgetQtySoldMonFuture	Double	Future Budget Quantity Sold
Budget Qty Sold Previous Year:
PrPriYrQtySoldLA	Double Read	Prior Year Brought Forward
PrPriYrQtySoldMon1	Double	Prior Year Month 1 Quantity Sold
PrPriYrQtySoldMon2	Double	Prior Year Month 2 Quantity Sold
PrPriYrQtySoldMon3	Double	Prior Year Month 3 Quantity Sold
PrPriYrQtySoldMon4	Double	Prior Year Month 4 Quantity Sold
PrPriYrQtySoldMon5	Double	Prior Year Month 5 Quantity Sold
PrPriYrQtySoldMon6	Double	Prior Year Month 6 Quantity Sold
PrPriYrQtySoldMon7	Double	Prior Year Month 7 Quantity Sold
PrPriYrQtySoldMon8	Double	Prior Year Month 8 Quantity Sold
PrPriYrQtySoldMon9	Double	Prior Year Month 9 Quantity Sold
PrPriYrQtySoldMon10	Double	Prior Year Month 10 Quantity Sold
PrPriYrQtySoldMon11	Double	Prior Year Month 11 Quantity Sold
PrPriYrQtySoldMon12	Double	Prior Year Month 12 Quantity Sold
PrPriYrQtySoldMonFuture	Double	Prior Year Future Quantity Sold
Discount Qty Band A:
PrDiscA_1_qty	Double Pro	Discount Table A, Break Level 1, Quantity
PrDiscA_1_rate	Double Pro	Discount Table A, Break Level 1, Rate
PrDiscA_2_qty	Double Pro	Discount Table A, Break Level 2, Quantity
PrDiscA_2_rate	Double Pro	Discount Table A, Break Level 2, Rate
PrDiscA_3_qty	Double Pro	Discount Table A, Break Level 3, Quantity
PrDiscA_3_rate	Double Pro	Discount Table A, Break Level 3, Rate
PrDiscA_4_qty	Double Pro	Discount Table A, Break Level 4, Quantity
PrDiscA_4_rate	Double Pro	Discount Table A, Break Level 4, Rate
PrDiscA_5_qty	Double Pro	Discount Table A, Break Level 5, Quantity
PrDiscA_5_rate	Double Pro	Discount Table A, Break Level 5, Rate
PrDiscA_6_qty	Double Pro	Discount Table A, Break Level 6, Quantity
PrDiscA_6_rate	Double Pro	Discount Table A, Break Level 6, Rate
PrDiscA_7_qty	Double Pro	Discount Table A, Break Level 7, Quantity
PrDiscA_7_rate	Double Pro	Discount Table A, Break Level 7, Rate
PrDiscA_8_qty	Double Pro	Discount Table A, Break Level 8, Quantity
PrDiscA_8_rate	Double Pro	Discount Table A, Break Level 8, Rate
PrDiscA_9_qty	Double Pro	Discount Table A, Break Level 9, Quantity
PrDiscA_9_rate	Double Pro	Discount Table A, Break Level 9, Rate
PrDiscA_10_qty	Double Pro	Discount Table A, Break Level 10, Quantity
PrDiscA_10_rate	Double Pro	Discount Table A, Break Level 10, Rate
Discount Qty Band B:
PrDiscB_1_qty	Double Pro	Discount Table B, Break Level 1, Quantity
PrDiscB_1_rate	Double Pro	Discount Table B, Break Level 1, Rate
PrDiscB_2_qty	Double Pro	Discount Table B, Break Level 2, Quantity
PrDiscB_2_rate	Double Pro	Discount Table B, Break Level 2, Rate
PrDiscB_3_qty	Double Pro	Discount Table B, Break Level 3, Quantity
PrDiscB_3_rate	Double Pro	Discount Table B, Break Level 3, Rate
PrDiscB_4_qty	Double Pro	Discount Table B, Break Level 4, Quantity
PrDiscB_4_rate	Double Pro	Discount Table B, Break Level 4, Rate
PrDiscB_5_qty	Double Pro	Discount Table B, Break Level 5, Quantity
PrDiscB_5_rate	Double Pro	Discount Table B, Break Level 5, Rate
PrDiscB_6_qty	Double Pro	Discount Table B, Break Level 6, Quantity
PrDiscB_6_rate	Double Pro	Discount Table B, Break Level 6, Rate
PrDiscB_7_qty	Double Pro	Discount Table B, Break Level 7, Quantity
PrDiscB_7_rate	Double Pro	Discount Table B, Break Level 7, Rate
PrDiscB_8_qty	Double Pro	Discount Table B, Break Level 8, Quantity
PrDiscB_8_rate	Double Pro	Discount Table B, Break Level 8, Rate
PrDiscB_9_qty	Double Pro	Discount Table B, Break Level 9, Quantity
PrDiscB_9_rate	Double Pro	Discount Table B, Break Level 9, Rate
PrDiscB_10_qty	Double Pro	Discount Table B, Break Level 10, Quantity
PrDiscB_10_rate	Double Pro	Discount Table B, Break Level 10, Rate
Discount Qty Band C:
PrDiscC_1_qty	Double Pro	Discount Table C, Break Level 1, Quantity
PrDiscC_1_rate	Double Pro	Discount Table C, Break Level 1, Rate
PrDiscC_2_qty	Double Pro	Discount Table C, Break Level 2, Quantity
PrDiscC_2_rate	Double Pro	Discount Table C, Break Level 2, Rate
PrDiscC_3_qty	Double Pro	Discount Table C, Break Level 3, Quantity
PrDiscC_3_rate	Double Pro	Discount Table C, Break Level 3, Rate
PrDiscC_4_qty	Double Pro	Discount Table C, Break Level 4, Quantity
PrDiscC_4_rate	Double Pro	Discount Table C, Break Level 4, Rate
PrDiscC_5_qty	Double Pro	Discount Table C, Break Level 5, Quantity
PrDiscC_5_rate	Double Pro	Discount Table C, Break Level 5, Rate
PrDiscC_6_qty	Double Pro	Discount Table C, Break Level 6, Quantity
PrDiscC_6_rate	Double Pro	Discount Table C, Break Level 6, Rate
PrDiscC_7_qty	Double Pro	Discount Table C, Break Level 7, Quantity
PrDiscC_7_rate	Double Pro	Discount Table C, Break Level 7, Rate
PrDiscC_8_qty	Double Pro	Discount Table C, Break Level 8, Quantity
PrDiscC_8_rate	Double Pro	Discount Table C, Break Level 8, Rate
PrDiscC_9_qty	Double Pro	Discount Table C, Break Level 9, Quantity
PrDiscC_9_rate	Double Pro	Discount Table C, Break Level 9, Rate
PrDiscC_10_qty	Double Pro	Discount Table C, Break Level 10, Quantity
PrDiscC_10_rate	Double Pro	Discount Table C, Break Level 10, Rate
Discount Qty Band D:
PrDiscD_1_qty	Double Pro	Discount Table D, Break Level 1, Quantity
PrDiscD_1_rate	Double Pro	Discount Table D, Break Level 1, Rate
PrDiscD_2_qty	Double Pro	Discount Table D, Break Level 2, Quantity
PrDiscD_2_rate	Double Pro	Discount Table D, Break Level 2, Rate
PrDiscD_3_qty	Double Pro	Discount Table D, Break Level 3, Quantity
PrDiscD_3_rate	Double Pro	Discount Table D, Break Level 3, Rate
PrDiscD_4_qty	Double Pro	Discount Table D, Break Level 4, Quantity
PrDiscD_4_rate	Double Pro	Discount Table D, Break Level 4, Rate
PrDiscD_5_qty	Double Pro	Discount Table D, Break Level 5, Quantity
PrDiscD_5_rate	Double Pro	Discount Table D, Break Level 5, Rate
PrDiscD_6_qty	Double Pro	Discount Table D, Break Level 6, Quantity
PrDiscD_6_rate	Double Pro	Discount Table D, Break Level 6, Rate
PrDiscD_7_qty	Double Pro	Discount Table D, Break Level 7, Quantity
PrDiscD_7_rate	Double Pro	Discount Table D, Break Level 7, Rate
PrDiscD_8_qty	Double Pro	Discount Table D, Break Level 8, Quantity
PrDiscD_8_rate	Double Pro	Discount Table D, Break Level 8, Rate
PrDiscD_9_qty	Double Pro	Discount Table D, Break Level 9, Quantity
PrDiscD_9_rate	Double Pro	Discount Table D, Break Level 9, Rate
PrDiscD_10_qty	Double Pro	Discount Table D, Break Level 10, Quantity
PrDiscD_10_rate	Double Pro	Discount Table D, Break Level 10, Rate
Discount Qty Band E:
PrDiscE_1_qty	Double Pro	Discount Table E, Break Level 1, Qty
PrDiscE_1_rate	Double Pro	Discount Table E, Break Level 1, Rate
PrDiscE_2_qty	Double Pro	Discount Table E, Break Level 2, Quantity
PrDiscE_2_rate	Double Pro	Discount Table E, Break Level 2, Rate
PrDiscE_3_qty	Double Pro	Discount Table E, Break Level 3, Quantity
PrDiscE_3_rate	Double Pro	Discount Table E, Break Level 3, Rate
PrDiscE_4_qty	Double Pro	Discount Table E, Break Level 4, Quantity
PrDiscE_4_rate	Double Pro	Discount Table E, Break Level 4, Rate
PrDiscE_5_qty	Double Pro	Discount Table E, Break Level 5, Quantity
PrDiscE_5_rate	Double Pro	Discount Table E, Break Level 5, Rate
PrDiscE_6_qty	Double Pro	Discount Table E, Break Level 6, Quantity
PrDiscE_6_rate	Double Pro	Discount Table E, Break Level 6, Rate
PrDiscE_7_qty	Double Pro	Discount Table E, Break Level 7, Quantity
PrDiscE_7_rate	Double Pro	Discount Table E, Break Level 7, Rate
PrDiscE_8_qty	Double Pro	Discount Table E, Break Level 8, Quantity
PrDiscE_8_rate	Double Pro	Discount Table E, Break Level 8, Rate
PrDiscE_9_qty	Double Pro	Discount Table E, Break Level 9, Quantity
PrDiscE_9_rate	Double Pro	Discount Table E, Break Level 9, Rate
PrDiscE_10_rate	Double Pro	Discount Table E, Break Level 10, Rate
PrDiscE_10_qty	Double Pro	Discount Table E, Break Level 10, Quantity
Other:
PrLastSaleDate	Date	Last Sales Date
PrLastUpdated	Date	Last Updated Date
PrIgnStkLevel	Yes/No-	Ignore Stock Levels Flag
BOM:
PrAssLevel	Integer Read	Assembly Level: the number of levels of components and sub-assemblies below the product assembly
BOM Sub Components:
PrBOMcode1^	Text 30 Pro	Sub componenent 1 In Cell Searching values in table ProdCode
PrBOMcodeQty1	Double Pro	Sub componenent qty 1
PrBOMcode2^	Text 30 Pro	Sub componenent 2 In Cell Searching values in table ProdCode
PrBOMcodeQty2	Double Pro	Sub componenent qty 2
PrBOMcode3^	Text 30 Pro	Sub componenent 3 In Cell Searching values in table ProdCode
PrBOMcodeQty3	Double Pro	Sub componenent qty 3
PrBOMcode4^	Text 30 Pro	Sub componenent 4 In Cell Searching values in table ProdCode
PrBOMcodeQty4	Double Pro	Sub componenent qty 4
PrBOMcode5^	Text 30 Pro	Sub componenent 5 In Cell Searching values in table ProdCode
PrBOMcodeQty5	Double Pro	Sub componenent qty 5
PrBOMcode6^	Text 30 Pro	Sub componenent 6 In Cell Searching values in table ProdCode
PrBOMcodeQty6	Double Pro	Sub componenent qty 6
PrBOMcode7^	Text 30 Pro	Sub componenent 7 In Cell Searching values in table ProdCode
PrBOMcodeQty7	Double Pro	Sub componenent qty 7
PrBOMcode8^	Text 30 Pro	Sub componenent 8 In Cell Searching values in table ProdCode
PrBOMcodeQty8	Double Pro	Sub componenent qty 8
PrBOMcode9^	Text 30 Pro	Sub componenent 9 In Cell Searching values in table ProdCode
PrBOMcodeQty9	Double Pro	Sub componenent qty 9
PrBOMcode10^	Text 30 Pro	Sub componenent 10 In Cell Searching values in table ProdCode
PrBOMcodeQty10	Double Pro	Sub componenent qty 10
PrBOMcode11^	Text 30 Pro	Sub componenent 11 In Cell Searching values in table ProdCode
PrBOMcodeQty11	Double Pro	Sub componenent qty 11
PrBOMcode12^	Text 30 Pro	Sub componenent 12 In Cell Searching values in table ProdCode
PrBOMcodeQty12	Double Pro	Sub componenent qty 12
PrBOMcode13^	Text 30 Pro	Sub componenent 13 In Cell Searching values in table ProdCode
PrBOMcodeQty13	Double Pro	Sub componenent qty 13
PrBOMcode14^	Text 30 Pro	Sub componenent 14 In Cell Searching values in table ProdCode
PrBOMcodeQty14	Double Pro	Sub componenent qty 14
PrBOMcode15^	Text 30 Pro	Sub componenent 15 In Cell Searching values in table ProdCode
PrBOMcodeQty15	Double Pro	Sub componenent qty 15
PrBOMcode16^	Text 30 Pro	Sub componenent 16 In Cell Searching values in table ProdCode
PrBOMcodeQty16	Double Pro	Sub componenent qty 16
PrBOMcode17^	Text 30 Pro	Sub componenent 17 In Cell Searching values in table ProdCode
PrBOMcodeQty17	Double Pro	Sub componenent qty 17
PrBOMcode18^	Text 30 Pro	Sub componenent 18 In Cell Searching values in table ProdCode
PrBOMcodeQty18	Double Pro	Sub componenent qty 18
PrBOMcode19^	Text 30 Pro	Sub componenent 19 In Cell Searching values in table ProdCode
PrBOMcodeQty19	Double Pro	Sub componenent qty 19
PrBOMcode20^	Text 30 Pro	Sub componenent 20 In Cell Searching values in table ProdCode
PrBOMcodeQty20	Double Pro	Sub componenent qty 20
PrBOMcode21^	Text 30 Pro	Sub componenent 21 In Cell Searching values in table ProdCode
PrBOMcodeQty21	Double Pro	Sub componenent qty 21
PrBOMcode22^	Text 30 Pro	Sub componenent 22 In Cell Searching values in table ProdCode
PrBOMcodeQty22	Double Pro	Sub componenent qty 22
PrBOMcode23^	Text 30 Pro	Sub componenent 23 In Cell Searching values in table ProdCode
PrBOMcodeQty23	Double Pro	Sub componenent qty 23
PrBOMcode24^	Text 30 Pro	Sub componenent 24 In Cell Searching values in table ProdCode
PrBOMcodeQty24	Double Pro	Sub componenent qty 24
PrBOMcode25^	Text 30 Pro	Sub componenent 25 In Cell Searching values in table ProdCode
PrBOMcodeQty25	Double Pro	Sub componenent qty 25
PrBOMcode26^	Text 30 Pro	Sub componenent 26 In Cell Searching values in table ProdCode
PrBOMcodeQty26	Double Pro	Sub componenent qty 26
PrBOMcode27^	Text 30 Pro	Sub componenent 27 In Cell Searching values in table ProdCode
PrBOMcodeQty27	Double Pro	Sub componenent qty 27
PrBOMcode28^	Text 30 Pro	Sub componenent 28 In Cell Searching values in table ProdCode
PrBOMcodeQty28	Double Pro	Sub componenent qty 28
PrBOMcode29^	Text 30 Pro	Sub componenent 29 In Cell Searching values in table ProdCode
PrBOMcodeQty29	Double Pro	Sub componenent qty 29
PrBOMcode30^	Text 30 Pro	Sub componenent 30 In Cell Searching values in table ProdCode
PrBOMcodeQty30	Double Pro	Sub componenent qty 30
PrBOMcode31^	Text 30 Pro	Sub componenent 31 In Cell Searching values in table ProdCode
PrBOMcodeQty31	Double Pro	Sub componenent qty 31
PrBOMcode32^	Text 30 Pro	Sub componenent 32 In Cell Searching values in table ProdCode
PrBOMcodeQty32	Double Pro	Sub componenent qty 32
PrBOMcode33^	Text 30 Pro	Sub componenent 33 In Cell Searching values in table ProdCode
PrBOMcodeQty33	Double Pro	Sub componenent qty 33
PrBOMcode34^	Text 30 Pro	Sub componenent 34 In Cell Searching values in table ProdCode
PrBOMcodeQty34	Double Pro	Sub componenent qty 34
PrBOMcode35^	Text 30 Pro	Sub componenent 35 In Cell Searching values in table ProdCode
PrBOMcodeQty35	Double Pro	Sub componenent qty 35
PrBOMcode36^	Text 30 Pro	Sub componenent 36 In Cell Searching values in table ProdCode
PrBOMcodeQty36	Double Pro	Sub componenent qty 36
PrBOMcode37^	Text 30 Pro	Sub componenent 37 In Cell Searching values in table ProdCode
PrBOMcodeQty37	Double Pro	Sub componenent qty 37
PrBOMcode38^	Text 30 Pro	Sub componenent 38 In Cell Searching values in table ProdCode
PrBOMcodeQty38	Double Pro	Sub componenent qty 38
PrBOMcode39^	Text 30 Pro	Sub componenent 39 In Cell Searching values in table ProdCode
PrBOMcodeQty39	Double Pro	Sub componenent qty 39
PrBOMcode40^	Text 30 Pro	Sub componenent 40 In Cell Searching values in table ProdCode
PrBOMcodeQty40	Double Pro	Sub componenent qty 40
PrBOMcode41^	Text 30 Pro	Sub componenent 41 In Cell Searching values in table ProdCode
PrBOMcodeQty41	Double Pro	Sub componenent qty 41
PrBOMcode42^	Text 30 Pro	Sub componenent 42 In Cell Searching values in table ProdCode
PrBOMcodeQty42	Double Pro	Sub componenent qty 42
PrBOMcode43^	Text 30 Pro	Sub componenent 43 In Cell Searching values in table ProdCode
PrBOMcodeQty43	Double Pro	Sub componenent qty 43
PrBOMcode44^	Text 30 Pro	Sub componenent 44 In Cell Searching values in table ProdCode
PrBOMcodeQty44	Double Pro	Sub componenent qty 44
PrBOMcode45^	Text 30 Pro	Sub componenent 45 In Cell Searching values in table ProdCode
PrBOMcodeQty45	Double Pro	Sub componenent qty 45
PrBOMcode46^	Text 30 Pro	Sub componenent 46 In Cell Searching values in table ProdCode
PrBOMcodeQty46	Double Pro	Sub componenent qty 46
PrBOMcode47^	Text 30 Pro	Sub componenent 47 In Cell Searching values in table ProdCode
PrBOMcodeQty47	Double Pro	Sub componenent qty 47
PrBOMcode48^	Text 30 Pro	Sub componenent 48 In Cell Searching values in table ProdCode
PrBOMcodeQty48	Double Pro	Sub componenent qty 48
PrBOMcode49^	Text 30 Pro	Sub componenent 49 In Cell Searching values in table ProdCode
PrBOMcodeQty49	Double Pro	Sub componenent qty 49
PrBOMcode50^	Text 30 Pro	Sub componenent 50 In Cell Searching values in table ProdCode
PrBOMcodeQty50	Double Pro	Sub componenent qty 50

Req = Field is required EOF = End of file, Stop when no more values

Pro = PostTrans Pro version needed to use this field Read = Read Only

XML = Un-attended PostTrans XML API for Sage 200

With data type Yes/No fields, if cell starts with 'y' or 'Y' is taken as TRUE

Where ^ denotes a In Cell Code Search, delete ^ at end of tag, to turn off code search

All Text fields are trimmed (spaces before) by default. Add ' to the end of the tag name to stop this.

Related Example Sheets

You can easily access the example sheets by pressing Help button, on the PostTrans Toolbar to access these related examples, or downloading them from the links below.


	Product Customer Price Structure	Sheet:'Customer Prices Structure' Extract, Add and Amend Customer Prices Main page for Customer Prices Update Help article for Customer Prices Update
	Product Customer Special Prices	Sheet:'Special Prices' Extract, Add and Amend Customer Special Prices Main page for Customer Prices Update
Static Data - Product:

	Product Records (all Fields)	Sheet:'Product Rec ALL' Allow Extract/Amend/Import of Product records Main page for Product records Import
	Stock Take Product Records	Sheet:'Stock Take' Allow Extract Current IN Stock figure, then adjust at later date to give Stock Take functionality Main page for Stock Take Product records Import
	Product Records	Sheet:'Product Rec' Allow Extract/Amend/Import of Product records Main page for Product records Import Help article for Product records Import
	Product Qty Breaks	Sheet:'Product Qty Breaks' Allow Extract/Amend/Import of Product Qty Breaks Records Main page for Product records Import Discounts Help article for Product records Import Discounts
	Product Budgets	Sheet:'Product Budget' Allow Extract/Amend/Import of Product Budgets Main page for Product records Import Budgets Help article for Product records Import Budgets
	Bill of Materials (Pro Version)	Sheet:'BOM' Extract, Add and Amend Bill of Material Main page for Bill of Material Update Help article for Bill of Material Update
	Product Category	Sheet:'Product Cat' Allow Extract/Amend/Import of Product Category records Main page for Product Category records Import Help article for Product Category records Import

Product

Releated Topics.

Save time updating

Import from Excel

Solve the Puzzle?

Great Customer Satisfaction

Power of Excel

Sage 200 Bins

Manufacturing

Project Accounting

Sage 50:Extract/Amend/Import Products

Page Contents

Related Pages

Import Product Features in Sage 50

Advantages

Examples of importing Sage 50 Products

Demonstration Video

Template Structure for Static Data

Common Features

In-Cell Searching

Extracting the Data

Amending Products Data

Importing the Data

File Import Button

Validation

Evaluation and License

What else can I do?

Frequently Asked Questions?

Other Useful Topics

PostTrans Tags which map to Sage 50

Related Example Sheets

Static Data - Product: