Web Extract CSV
Description
This is our most basic web integration solution where we provide you with a CSV extract which you can use for loading into your web site
License
This is a licensed additional module which can be activated within Vision Commerce. In order to use this feature a charge is made.
Version
Version 3 is available in systems prior to v2.7.0
Version 4 is available in systems from v2.7 onwards
Overview
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 them directly to your website using FTP or you can download to a local directory on your server.
Automation
It is possible to 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 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 issue as you have a workaround in place, but in general, once 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 | 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 | Y | ||||
COO | AN | 6 | Y | |||
COO_Name | Y | |||||
Region | Y | |||||
Region_Name | Y | Y | ||||
Group | Y | |||||
Group_Name | Y | |||||
Style | Y | |||||
Style_Name | Y | Y | ||||
Type | Y | |||||
Type_Name | Y | Y | ||||
ProdAnal6 | Y | |||||
ProdAnal6_Name | Y | |||||
UDF_Prod_Anal1 | Y | |||||
UDF_Prod_Anal1_Name | Y | 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.
Price List
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
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.
Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.