/
Web Extract CSV

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

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





Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.