Page Comparison

...

This is our most basic web integration solution where we provide you with a csv CSV extract which you can use for loading into your web site

...

The module will generate three files

Product and Stock
Price List
Tasting Notes

These extracts are run manually from the application and you can choose whether to send then them directly to your web site website using FTP or you can download to a local directory on your server.

Automation

It is possible to setup set up a windows schedule job to also run the extract and whilst we can set this up for you, however, the operation of it thereafter is is outside of our control, if it fails you can simply run it manually and ask us to have a look at it. This would not be considered a priority issues issue as you have a workaround in place, but in general, once its it's scheduled, it tends to just run forever..

To run them manually please refer to the wiki manual subject of Web Extract

Product CSV

Field Name	Type	Length	Version3 (old name)	Version4	Unique	Comments
Identifier	AN	12	Y	Y


ProductCode	AN	20	Y	Y	Y	Unique Product Identifier
EANCase	AN	18	N	Y

	EAN Barcode Number - normally numerical only.
EANSubCase	AN	18	N	Y

		EAN Barcode Number - normally numerical only.
ProductDescription	AN	50	Y	Y


ProductDescription2	AN	50	Y	N

		This field is no longer being used for documents or any output layouts.
Vintage	AN	4	Y	Y

	Will be either a 4 digit year YYYY or NA or NV
SPC	Integer	6	Y (BottlesperCase)	Y

	Singles per Case
SS	Decimal	8.5	Y (BottleSize)	Y

		Single Size in centiliters
ABV	Decimal	3.5

Y

	Stength in %
TSinglesAvailable	Int	12	Y (TotalConvertedSingles)	Y

The total stock in bottles available to sell.

(Available to sell = STOCK - Orders not yet completed (orders held will be included))

TCaseAvailable

Int

12

Y (AvailableStock)

Y

		This is the total available singles / Singles per case (rounded down)
OptionExclude	Bit

Y (ExcludefromWeb)

Y

		Exclude from Web option
OptionSingles	Bit

Y (AllowSingles)

Y

		Do you sell single bottles of this product
OptionSellZero	Bit

N

Y

		Sell even if no stock (for EP)
OptionRetail	Bit

Y

		Is this a Retail Product
AvailableFrom	Date				dd/mm/yy When this product is available from.
Product_CaseDP	Decimal	8.5	Y (StdCaseSellPrice)	Y

		Product Sales Price Duty Paid for a Case
Product_SingleDP	Decimal	8.5	N	Y

		Product Sales Price Duty Paid for a Bottle
Producer

N

Y


Producer_Name

Y


COO	AN	6

Y


COO_Name

Y


Region

Y


Region_Name

Y


Group

Y


Group_Name

Y


Style

Y


Style_Name

Y


Type

Y


Type_Name

Y


ProdAnal6

Y


ProdAnal6_Name

Y


UDF_Prod_Anal1

Y


UDF_Prod_Anal1_Name

Y


UDF_Prod_Anal2

Y


UDF_Prod_Anal2_Name

Y


UDF_Prod_Anal3

Y


UDF_Prod_Anal3_Name

Y


UDF_Prod_Anal4

Y


UDF_Prod_Anal4_Name

Y


UDF_Prod_Anal5

Y


UDF_Prod_Anal5_Name

Y


UDF_Prod_Anal6

Y


UDF_Prod_Anal6_Name

Y


DutyPerSingle	Decimal	8.5	Y	The duty amount per single bottle.
Weight	Decimal	8.5

Y

		GrossWeight per case
Product_CaseUB	Decimal	8.5	Y	Product Sales Price Under Bond for a Case
Product_SingleUB	Decimal	8.5	Y	Product Sales Price Under Bond for a Bottle

Delisted Products will not be exported.

...

There is also a web price list extract. If you want to add the product but you also want to have different pricing for different customers, then the web price list is an output of all prices for all products, we then provide the following fields

Code Block
A sample file is available here

...

Name	Type	Length	Notes
PKPriceList	Int	16


WebPriceGroupCode	AN	6


PriceGroupName	AN	30


IsLive	Bit

		Will remain but will only contain lines which ARE live
IsEP	Bit		Is this an EnPrimeur Price list
IsPromo	Bit
StartDate	DateTime


EndDate	DateTime


Notes	AN	60	Any notes for this price list
PriceIncVAT	Bit


ProductCode	AN	20	Unique Product Code
QuantityFrom	Int


QuantityTo	Int


CasePrice	decimal	8.3	Duty Paid Price per case
SinglePrice	decimal	8.3	Duty Paid price per single
CasePriceUB	decimal	8.3	New feature coming soon
SinglePriceUB	decimal	8.3	New feature coming soon.

Will only contain LIVE price lists, as active and DATE ENDS is not in the past.

Tasting Notes

Name	Type	Length	Notes
ProductCode	AN	20	Unique field which links to the product table
TastingNotes	HTML


NoteDate	datetime

If no notes exists then nothing will be exported.

...

Versions Compared

Old Version 14

New Version Current

Key

Automation

Product CSV

Tasting Notes