Product Export - ScaleLink Pro and Sam (Wedderburn) Interface

 

Back Office > Data Export > Export Scale Data

 

Description

 

This menu item is used to export changed Product pricing to ScaleLink Pro. For this interface to work, all scale PLU's must be in the same Family and all Product Codes must be numeric. 

 

NoteProducts with Product Codes containing alphabetic characters will not be exported. Keep Fruit and Veg Stores using 02 Barcodes to 4 digit PLU numbers.

 


Generic Scales Data Export

 

 

This screen is accessed from here.

 

Generic Scales Export

 

  • Export Path - Displays/Enter the ScaleLink Pro Export File, will be exported to.
  • Last Export Date - Displays the date the Product Changes were last exported.
  • Price Level - Select from the drop down list the Price Levels to send to ScaleLink Pro.
  • Family Filter - Select from the drop down list the Family of Products to send to ScaleLink Pro.
  • Include Description field - Select to include in export.
  • Export all for selected Family - Select to include in export.
  • Export Scales PLU - Select to export all Products that have changed since the Last Export Date. For the file format click here. For post export operation information click here.

 


Sam (Wedderburn) Scales Data Export

 

 

This screen is accessed from here.

 

SAM (Wedderburn) Scales Export

 

Settings for Windows x32 bit.

 

  • Export Folder: C:\Program Files\Wedderburn\SAM\AppInOut
  • PIE Location: C:\Program Files\Wedderburn\SAM\PIE.exe
  • PIE Parameters: /i /w /s "import.csv"
  • Barcode Format: 07

 

Settings for Windows x64 bit.

 

  • Export Folder: C:\Program Files (x86)\Wedderburn\SAM\AppInOut
  • PIE Location: C:\Program Files (x86)\Wedderburn\SAM\PIE.exe
  • PIE Parameters: /i /w /s "import.csv"
  • Barcode Format: 07

 

You can send out a full update of all Products to the scales or just the changes that have been made to the Scale PLU's since the last time you sent the changes.

 

If the PIE application is not present it will still export the file out and you would have to manually run the PIE application to import the PLU's into the Scale Management Software.

 

File Format.

1,531,1,1,07,0200531000000,2450,0,0,"HAM"

 


CAS LP1 Label Scales Data Export

 

 

This screen is accessed from here.

 

CAS LP1 Label Scales Export

 

As per the CAS LP1 file format.

 


WEDGE (Wedderburn) Scales Data Export

 

 

This screen is accessed from here.

 

WEDGE (Wedderburn) Scales Export

 


Export Scale Data File Format

 

Field Name

Data Type

Notes

Plu_No

Integer

This field represents the Product Code not the PLU number in SwiftPOS.

UnitPrice

Currency

This field represents the Price in cents.

 

For Example:

Plu_No,UnitPrice

10018,0

10019,0

10020,0

 


Appendix B: Extended Record Format

 

Field Name

Value

Notes

Record Status

1

If the value is 1 then the record is marked for change and will be sent to the device.

PLU Code

1-19,999

This is a unique PLU number across the system.

Location Code

1

Multiple Locations could be handled with additional Families if required but only one Location supported at this stage.

Group Code

1

If product variety group is required then they would need to be linked to the Reporting Groups or Categories.

EAN-8 / EAN-13 Barcode format code

4 or 7 (NZ)

Barcode Format code: 04: FF-CCCCC-PCD-PPPP-CD

Barcode Format code: 07 is now supported

EAN-13 Barcode Number


13 digit Barcode Format (full EAN-13 code).

Price in cents

1-999999

The value is expressed in cents

PLU status

0 or 1

If Sell Size is 1 then the PLU is a non-weighted item. If the Sell Size is anything other than 1 then the PLU is a weighed item Eg: Scale PLU.

Tare in gram

0-999

The tare weight in grams. This is the weight of the packaging.

Product Name

 

This is the Description of the Product

 


Priced Barcodes Overview

 

A priced Barcode is a Barcode which not only defines WHAT an item is but also the PRICE it is to be sold for. Normal Barcodes only identify the item.
An example is:

 

  • 0270008003031

 

In this case the "02" identifies it as a priced Barcode.
The "70008"  identifies the Product
The "0" is the check digit.
The "0303" specifies a price of $3.03.
The final digit is a check digit which allows the scanner to verify that it has correctly read the Barcode.
Both of these codes identify the same Product, just different amounts of it.

Examples of Products which use priced Barcodes are;

 

  • Pre-packed meat.
  • Pre-packed fruit and veg.
  • Deli goods sold in a supermarket with Barcode printing scales.

 

"02" and "20" Barcode Support

 

The SwiftPOS Touch terminals automatically recognise and interpret Barcodes that start with the numbers 02 or 20.

 

These Barcodes are typically used with goods that are weighed and a specific Barcode label printed indicating the PLU number and the price. Typical applications of the 02 code are in delicatessens and grocery stores, while the 20 code is typically used in wholesale applications. The quantity is always selected as 1 and the price of the relevant PLU must be set to open. Format is as follows:

 

Start code

PLU number

Check digit

Price in cents

Check digit

02

5 digits

1 digit

4 digits

1 digit

20

4 digits

1 digit

5 digits

1 digit

 


Operation - Post Export

 

  1. After you have exported the data from SwiftPOS.
  2. Open ScaleLink Pro.
  3. Select Tools > Import from Text File...
  4. Select the SCALESPLU.TXT file (it will be in the Export Path specified above).
  5. Change Operation to Updates.

 

  1. Select OK.

 


Related Topics

 

  1. Card Masking
  2. Data Export
  3. Import/Export Overview