Price Tags | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Working with Price Tag Types (WPTY) |
Price tags are labels that you can print and affix to items prior to distribution to your retail stores. The price tag can contain information such as the item number and SKU, price, UPC barcode, and item information such as long SKU department, long SKU class, and long SKU size.
Price tag type: You can use the Working with Price Tag Types (WPTY) menu option to define the types of price tags that you can assign to an item and the printer used to print the price tags. CWSerenade is delivered with 9 different price tag types; see Delivered Price Tag Types.
Assigning a price tag type to an item: Once you define the price tag types, you can use the Tag Type field on the Change or Create Item Screen to assign a price tag type to an item.
Creating a price tag batch: The system creates a price tag batch that contains the price tags to print for an item when you:
• generate picks for orders whose order type matches the order type defined in the Order Type to Print Price Tags during Pick Generation (M28) system control value.
• process an RF PO Receipt transaction for an item that is assigned to a price tag type.
• process a Store Transfer Receipt transaction for an item that is assigned to a price tag type.
• manually create a price tag batch in the Working with Price Tags (WPTG) menu option.
See Creating a Price Tag Batch for more information.
Printing price tags: The system prints price tags when you:
• process an RF PO Receipt transaction for an item that is assigned to a price tag type.
• process a Store Transfer Receipt transaction for an item that is assigned to a price tag type.
• select Print for a price tag batch on the Work with Price Tags Screen.
• select Print for an individual price tag on the Work with Price Tag Detail Screen.
See Printing Price Tags for more information.
Working with price tags: You can use the Working with Price Tags (WPTG) menu option to:
• create a price tag batch or add an item to an existing price tag batch.
• change the price tag type and the number of price tags to print for an item in a price tag batch.
• print the price tags for an item in a price tag batch or print all of the price tags in a price tag batch.
• delete an item from a price tag batch or delete the entire price tag batch.
Purging price tags: Price tags remain in CWSerenade until you:
• manually delete them in the Working with Price Tags (WPTG) menu option.
• use the PPT Purge Printed Price Tags (program name PFPPT) periodic function to purge price tag batches in the Price Tag Batch table that are in a P Printed status.
In this topic:
• Monarch Printer for Price Tags
• Assigning a Price Tag Type to an Item
• Price Tag Batch # Number Assignment Value
• Price Tag Data Mapping Table
For more information: See:
• Working with Price Tag Types (WPTY) for more information on how to configure the types of price tags that you can assign to an item.
• Working with Price Tags (WPTG) for more information on creating, updating, printing, and deleting price tags.
The system creates a price tag batch, using the next available number in the Price Tag Batch # number assignment, when you:
• generate picks for orders whose order type matches the order type defined in the Order Type to Print Price Tags during Pick Generation (M28) system control value; see Creating a Price Tag Batch during Pick Slip Generation.
• process an RF PO Receipt transaction for an item that is assigned to a price tag type; see Creating a Price Tag Batch for an RF PO Receipt Transaction.
• process a Store Transfer Receipt transaction for an item that is assigned to a price tag type; see Creating a Price Tag Batch for an RF Store Transfer Receipt Transaction.
• select Create on the Work with Price Tags Screen; see Creating a Miscellaneous Price Tag Batch.
• select Create from Order on the Work with Price Tags Screen; see Creating a Price Tag Batch Based on Order.
Creating a Price Tag Batch during Pick Slip Generation
The system creates a price tag batch when you generate picks for orders whose order type matches the order type defined in the Order Type to Print Price Tags during Pick Generation (M28) system control value.
In this situation, the system:
• creates a new price tag batch in the Price Tag Batch table, using the next available number in the Price Tag Batch # number assignment. The system assigns the billing batch number associated with the pick slip generation run to the price tag batch. The Status of the price tag batch is O Open since the system does not immediately print price tags during pick slip generation for the price tag batch.
• creates a price tag detail for each item on the pick that is assigned to a price tag type. The system uses the pick quantity as the number of tags to print for each item.
The price tag batch displays on the Work with Price Tags Screen in an O Open status. You can use this menu option to:
• add an item to the price tag batch; see Create/Change Price Tag Detail Screen.
• update the number of tags for an item or change the price tag type to print for the item; see Create/Change Price Tag Detail Screen.
• print the price tags in the batch; see Printing All Price Tags in a Price Tag Batch and Printing an Individual Price Tag in a Price Tag Batch.
Note: If none of the items on the order are assigned to a price tag type, the system creates a price tag batch that does not contain any details.
For more information: See Working with Price Tags (WPTG) for more information on working with the price tag batch.
Creating a Price Tag Batch for an RF PO Receipt Transaction
The system creates a price tag batch when you process an RF PO Receipt transaction for each item on the PO that is assigned to a price tag type. A separate price tag batch is created for each separate RF PO Receipt session. For example, if you receive items on 2 different POs in the same RF PO Receipt session, the system creates one price tag batch that contains the items on both POs.
To create:
1. |
On the RF PO Select Screen, enter the purchase order number you wish to receive. Use the Price Tags Option field on this screen to indicate whether you wish to print price tags for the items on the PO that are assigned to a price tag type. • A = Print All Tags. This option allows you to print price tags for all of the items on the PO prior to receiving the PO. With this option, the system: • creates a price tag batch in the Price Tag Batch table, using the next available number in the Price Tag Batch # number assignment. • creates a Price Tag Detail for each item on the PO that is assigned to a price tag type. The system uses the Quantity ordered in the PO Detail table as the number of tags to create for each item. • immediately prints the tags in the batch; see Printing Price Tags. • R = Print Received Tags. This option allows you to print price tags only for the items on the PO that are received in this transaction. With this option, the system: • creates a price tag batch in the Price Tag Batch table, using the next available number in the Price Tag Batch # number assignment. • creates a Price Tag Detail for each item received on the PO that is assigned to a price tag type. The system uses the receipt quantity as the number of tags to create for each item. • immediately prints the tags in the batch; see Printing Price Tags. • blank = The system does not create a price tag batch or print price tags. |
2. |
The price tag batch displays on the Work with Price Tags Screen in a P Printed status. You can use this menu option to: • add an item to the price tag batch; see Create/Change Price Tag Detail Screen. • update the number of tags for an item or change the price tag type to print for the item; see Create/Change Price Tag Detail Screen. • print the price tags in the batch; see Printing All Price Tags in a Price Tag Batch and Printing an Individual Price Tag in a Price Tag Batch. |
For more information: See RF PO Receipt Transaction.
Creating a Price Tag Batch for an RF Store Transfer Receipt Transaction
The system creates a price tag batch when you process an RF Store Transfer Receipt transaction for each item on the store transfer that is assigned to a price tag type. A separate price tag batch is created for each separate RF Store Transfer Receipt session. For example, if you receive items on 2 different store transfers in the same RF Store Transfer Receipt session, the system creates one price tag batch that contains the items on both store transfers.
To create:
1. |
On the RF Transfer ID Select Screen, enter the store transfer ID you wish to receive. Use the Price tags option field on this screen to indicate whether you wish to print price tags for the items on the store transfer that are assigned to a price tag type. • A = Print All Tags. This option allows you to print price tags for all of the items on the store transfer prior to receiving the store transfer. With this option, the system: • creates a price tag batch in the Price Tag Batch table, using the next available number in the Price Tag Batch # number assignment. • creates a Price Tag Detail for each item on the store transfer that is assigned to a price tag type. The system uses the Quantity due in the Store Transfer Receipts table as the number of tags to create for each item. • immediately prints the tags in the batch; see Printing Price Tags. • R = Print Received Tags. This option allows you to print price tags only for the items on the store transfer that are received in this transaction. With this option, the system: • creates a price tag batch in the Price Tag Batch table, using the next available number in the Price Tag Batch # number assignment. • creates a Price Tag Detail for each item received on the store transfer that is assigned to a price tag type. The system uses the receipt quantity as the number of tags to create for each item. • immediately prints the tags in the batch; see Printing Price Tags. • blank = The system does not create a price tag batch or print price tags. |
2. |
The price tag batch displays on the Work with Price Tags Screen in a P Printed status. You can use this menu option to: • add an item to the price tag batch; see Create/Change Price Tag Detail Screen. • update the number of tags for an item or change the price tag type to print for the item; see Create/Change Price Tag Detail Screen. • print the price tags in the batch; see Printing All Price Tags in a Price Tag Batch and Printing an Individual Price Tag in a Price Tag Batch. |
For more information: See RF Store Transfer Receipt Transaction.
Creating a Miscellaneous Price Tag Batch
Use this option to create a price tag batch to which you can manually add items. You can add items to the price tag batch that are not assigned to a price tag type. In addition, if the item is assigned to a price tag type, you can override it.
Note: In order to create a miscellaneous price tag batch, you must have authority to the Create/Change Price Tags (J09) secured feature.
To create:
1. |
Select Create on the Work with Price Tags Screen. |
2. |
The system creates a price tag batch in the Price Tag Batch table, using the next available number in the Price Tag Batch # number assignment. The Status of the price tag batch is O Open. |
3. |
Select Work with Batch for the price tag batch you just created to advance to the Work with Price Tag Detail Screen. |
4. |
At the Work with Price Tag Detail screen, select Create to advance to the Create/Change Price Tag Detail Screen. |
5. |
At the Create/Change Price Tag Detail screen: • Enter the item and SKU you wish to assign to the price tag batch. • Define the number of tags you wish to print for the item and the type of price tag. The system allows you to override the price tag type that may be assigned to the item. • Select OK to create the Price Tag Detail. |
6. |
Repeat step 5 for each item you wish to add to the price tag batch. |
7. |
Once the price tag batch is created, you can print the tags in the batch; see Printing All Price Tags in a Price Tag Batch and Printing an Individual Price Tag in a Price Tag Batch. |
Creating a Price Tag Batch Based on Order
Use this option to create a price tag batch for the items on an order that are assigned to a price tag type.
To create:
1. |
Select Create from Order on the Work with Price Tags Screen to advance to the Enter Order - Ship To window. |
2. |
At the Enter Order - Ship To window, enter a valid order number and ship to number and select OK. If you do not define a ship to number, 1 defaults. Note: If there are no items on the order assigned to a price tag type, the system displays the error No Items Eligible for Price Tags. |
3. |
The system: • creates a price tag batch in the Price Tag Batch table, using the next available number in the Price Tag Batch # number assignment. The Status of the price tag batch is O Open. • creates a Price Tag Detail for each item on the order assigned to a price tag type. The system uses the Quantity ordered in the Order Detail table as the number of tags to create for each item. |
4. |
At the Price Tag Batch successfully created for Order window, select OK to return to the Work with Price Tags screen. |
5. |
The new price tag batch created displays on the Work with Price Tags screen. |
6. |
Select Work with Batch for the price tag batch you just created to advance to the Work with Price Tag Detail Screen. |
7. |
At the Work with Price Tag Detail screen, the items on the order assigned to a price tag type display on the screen. • The # of Tags is the quantity of the item ordered. • The Tag Type is the price tag type assigned to the item. |
8. |
Optionally, select Change for an item in the price tag batch to advance to the Create/Change Price Tag Detail Screen. At this screen, you can change the number of tags to print for the item and/or the tag type. |
9. |
Once the price tag batch is created, you can print the tags in the batch; see Printing All Price Tags in a Price Tag Batch and Printing an Individual Price Tag in a Price Tag Batch. |
For each item assigned to a price tag batch, the system creates a record in the Price Tag Work table. You can review the items assigned to a price tag batch on the Work with Price Tag Detail Screen.
Price Tag Work Table |
|
Field |
Description |
Batch # |
The price tag batch number assigned to the item. Numeric, 9 positions. |
Item Number |
The item number for which you wish to print a price tag. Alphanumeric, 12 positions. |
SKU Code |
The SKU code for the item for which you wish to print a price tag. Alphanumeric, 14 positions. |
Number of Tags |
The number of tags to print for the item. • If you created the price tag batch during pick slip generation, this is the quantity of the item on the pick. • If you created the price tag batch during RF PO Receipt, this is: • the Quantity ordered in the PO Detail table if the Price Tags Option field was set to A Print All Tags. • the quantity received if the Price Tags Option field was set to R Print Received Tags. • If you created the price tag batch during RF Store Transfer Receipt, this is: • the Quantity due in the Store Transfer Receipts table if the Price Tags Option field was set to A Print All Tags. • the quantity received if the Price Tags Option field was set to R Print Received Tags. • If you created the price tag batch using the Create from Order option on the Work with Price Tags Screen this is the quantity of the item ordered. • If you created the price tag batch using the Create option on the Work with Price Tags Screen this is the quantity you entered in the # Tags field on the Create/Change Price Tag Detail Screen. |
Tag Type |
The type of price tag to print for the item; this is the price tag type assigned to the item unless you manually changed the tag type on the Create/Change Price Tag Detail Screen. See Working with Price Tag Types (WPTY) and Delivered Price Tag Types. |
In addition, the tag type assigned to the Price Tag Work record determines the additional data elements to print on the price tag; see Price Tag Data Mapping Table and Delivered Price Tag Types.
Data Element |
Source Field / Table |
2 |
The ITM Number from the Item table. |
3 |
The SEW code from the SKU table. |
5 |
The Price from the Item Price table whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date. This price represents the sale price of the item on the price tag. |
6 |
The UPC from the Item UPC table for the UPC Type defined in the Default UPC Type for Slotting New Items (L84) system control value. |
7 |
The LSD Department from the Item table. |
8 |
The Long SKU Class from the Item table. |
9 |
The SEO code from the SKU table. |
10 |
The Long SKU Vendor from the Item table. |
11 |
The Season from the Item table. |
12 |
The SET code from the SKU table. |
13 |
The List Price from the SKU table. This price represents the regular price of the item on the price tag. |
The system prints a price tag when you:
• process an RF PO Receipt transaction for an item that is assigned to a price tag type; see Creating a Price Tag Batch for an RF PO Receipt Transaction.
• process a Store Transfer Receipt transaction for an item that is assigned to a price tag type; see Creating a Price Tag Batch for an RF Store Transfer Receipt Transaction.
• select Print for a price tag batch on the Work with Price Tags Screen; see Printing All Price Tags in a Price Tag Batch.
• select Print for an individual price tag on the Work with Price Tag Detail Screen; see Printing an Individual Price Tag in a Price Tag Batch.
Printer setup: The system uses the printer defined for the price tag type in the Price Tag Type table and the Price Tag properties to print each price tag. See Monarch Printer for Price Tags and Price Tag Properties.
Print sort: Price tags print in item number, price tag type sequence.
If the price tags do not print: See Monarch Printer Troubleshooting.
Printing All Price Tags in a Price Tag Batch
Use this option to print all of the price tags in a price tag batch.
To print:
1. |
Select Print for a price tag batch on the Work with Price Tags Screen. |
2. |
The system: • displays the message Price Tag Batch successfully printed once processing is complete. • updates the status of the price tag batch to P. |
Printing an Individual Price Tag in a Price Tag Batch
Use this option to print the price tags for an item in a price tag batch.
To print:
1. |
Select Print for a price tag detail on the Work with Price Tag Detail Screen. |
2. |
The system displays the message Price Tag Batch successfully printed once processing is complete. Note: Printing the price tags for an item in a price tag batch does not update the status of a price tag batch to P Printed. |
Purpose: Before you can use price tags, you must complete the required setup.
• Monarch Printer for Price Tags
• Monarch Printer Troubleshooting
• Assigning a Price Tag Type to an Item
• Price Tag Batch # Number Assignment Value
• Price Tag Data Mapping Table
Monarch Printer for Price Tags
A Monarch printer is required to print price tags.
The recommended Monarch printer to use is the Monarch1 9855 RFIDMP (Radio Frequency Identification Multi-Protocol) Printer. This printer has been engineered to program (encode) an RFID label (also called RFID tag) before the label’s format is printed. RFID tags contain an embedded RFID chip inlay (chip and antenna). You can also print text, graphics, and bar codes on thermal transfer (ribbon) and thermal direct labels or tags.
Contact your MICROS representative if you wish to use a different Monarch printer.
Visit the Avery Dennison2 Monarch Products and Services web site (www.monarch.averydennison.com) for more information about Monarch printers and to download documentation about your Monarch printer.
Monarch printer setup: The PRINTER_CONNECTION property indicates how CWSerenade connects to the Monarch printer. This setting must be set to WIN, indicating the Monarch printer is set up as a Windows Print Service.
Working with Customer Properties (PROP) stores information required to print price tags.
Property Name |
Description |
Printer Type A Monarch printer is required to print price tags; see Monarch Printer for Price Tags. |
|
MONARCH_PTR_TYPE |
Enter the type of Monarch printer used to print price tags. The recommended Monarch printer type is MON_9855. |
Window Service - Printer Names Defines the name of the Monarch printer when it is set up as a Windows Print service; in this situation, the PRINTER_CONNECTION property must be WIN. Defining More Than One Monarch Printer You can insert a line to define more than one Monarch printer. For example, if you want to use three printers to print price tags, you would define three lines similar to the following: WMON01_PTR=\\\\build-01\\Monarch9855 WMON02_PTR=\\\\build-01\\Monarch9855_2 WMON03_PTR=\\\\build-01\\Monarch9855_3 where MON01_PTR represents the printer ID and \\\\build-01\\Monarch9855 represents the name of the server where the Monarch Print Driver is installed and the name of the Monarch printer used to print the price tag label. Make sure you do not use the same printer ID for more than one printer. In addition, the printer ID should not be more than 10 positions since you need to define this printer ID in the Printer Name field in Working with Price Tag Types (WPTY).
Important: If you are using Windows 2008 or Windows 2008 R2, your entries MUST be in all uppercase; otherwise the entries are case-sensitive. |
|
WMON01_PTR where MON01_PTR is the name of the printer |
The name of the server where the Monarch Print Driver is installed and the name of the Monarch printer used to print the price tag label. Enter the name of the server and the name of the Monarch printer in the following format: WMON01_PTR=\\\\server_name\\Monarch_printer_name |
Printer Configuration Defines how to communicate with the Monarch printer. |
|
WIN = The Monarch printer is set up as a Windows Print Service; see Setting Up the RF Printer Using Windows Print Service. You must complete the Window Service - Printer Names settings. |
|
The following settings define the location for the CSV file used to determine the content and format of each price tag label. A separate CSV file is used for each type of label. Default label format location: The default location used to store label formats is C:\CWSerenade\LabelFormats, where C: is the root drive where CWSerenade is installed. This location contains the base CWSerenade label formats and any unique label formats that have been defined. Important: Do not change the information in the CSV files; changing the information in the CSV file will cause errors when printing labels. |
|
where 1 is the Price Tag Type defined in the Price Tag Type table |
The location on the CWSerenade application server where the MON01_label.csv file is located. The contents of this file determine the information that prints on the price tag label and how the information is presented on the label. The default location is the following, where C: is the root drive where CWSerenade is installed: C:\\CWSerenade\\LabelFormats\\MON01_label.csv |
where 2 is the Price Tag Type defined in the Price Tag Type table |
The location on the CWSerenade application server where the MON02_label.csv file is located. The contents of this file determine the information that prints on the price tag label and how the information is presented on the label. The default location is the following, where C: is the root drive where CWSerenade is installed: C:\\CWSerenade\\LabelFormats\\MON02_label.csv |
where 3 is the Price Tag Type defined in the Price Tag Type table |
The location on the CWSerenade application server where the MON03_label.csv file is located. The contents of this file determine the information that prints on the price tag label and how the information is presented on the label. The default location is the following, where C: is the root drive where CWSerenade is installed: C:\\CWSerenade\\LabelFormats\\MON03_label.csv |
where 20 is the Price Tag Type defined in the Price Tag Type table |
The location on the CWSerenade application server where the MON20_label.csv file is located. The contents of this file determine the information that prints on the price tag label and how the information is presented on the label. The default location is the following, where C: is the root drive where CWSerenade is installed: C:\\CWSerenade\\LabelFormats\\MON20_label.csv |
where 40 is the Price Tag Type defined in the Price Tag Type table |
The location on the CWSerenade application server where the MON40_label.csv file is located. The contents of this file determine the information that prints on the price tag label and how the information is presented on the label. The default location is the following, where C: is the root drive where CWSerenade is installed: C:\\CWSerenade\\LabelFormats\\MON40_label.csv |
where 50 is the Price Tag Type defined in the Price Tag Type table |
The location on the CWSerenade application server where the MON50_label.csv file is located. The contents of this file determine the information that prints on the price tag label and how the information is presented on the label. The default location is the following, where C: is the root drive where CWSerenade is installed: C:\\CWSerenade\\LabelFormats\\MON50_label.csv |
where 60 is the Price Tag Type defined in the Price Tag Type table |
The location on the CWSerenade application server where the MON60_label.csv file is located. The contents of this file determine the information that prints on the price tag label and how the information is presented on the label. The default location is the following, where C: is the root drive where CWSerenade is installed: C:\\CWSerenade\\LabelFormats\\MON60_label.csv |
where 65 is the Price Tag Type defined in the Price Tag Type table |
The location on the CWSerenade application server where the MON65_label.csv file is located. The contents of this file determine the information that prints on the price tag label and how the information is presented on the label. The default location is the following, where C: is the root drive where CWSerenade is installed: C:\\CWSerenade\\LabelFormats\\MON65_label.csv |
Monarch Printer Troubleshooting
Logs: As you print price tags, the system writes a message to the CWSerenade Application Log and CWDirect Log indicating the label printed:
08:59:31,419 INFO APP - MONARCH Label printing ... Type: 1
08:59:31,606 DEBUG APP - Printer: \\build-01\Monarch9855
08:59:31,606 DEBUG APP - Printer: \\build-01\Monarch9855_2
08:59:31,606 DEBUG APP - Printer: \\build-01\ZDesigner
08:59:31,606 DEBUG APP - Printer: Microsoft XPS Document Writer
Price tag print error: If an error occurs when printing price tags, the system includes an error message about the price tag in the CWSerenade Application Log and CWDirect Log. For example, if an error occurs when the system tries to print a price tag, an error message similar to the following displays in the log:
12:52:10,156 INFO APP - MONARCH Label printing ... Type: 1
12:52:10,359 DEBUG APP - Printer: \\build-01\Monarch9855
12:52:10,359 DEBUG APP - Printer: \\build-01\Monarch9855_2
12:52:10,359 DEBUG APP - Printer: \\build-01\ZDesigner
12:52:10,359 DEBUG APP - Printer: Microsoft XPS Document Writer
12:52:10,359 DEBUG APP - null Printer not found value is null
12:52:18,000 ERROR APP - I/O problem while opening connection to: 152.85.1.4 Port: 8507
Correcting Monarch Printer Errors
If an error occurs when printing price tags, check the following:
• Verify the settings for the Price Tag Properties.
• Verify that the printer ID defined in the Printer Name field in Working with Price Tag Types (WPTY) matches the printer ID defined in the Window Service - Printer Names properties.
• Check the display window on the Monarch printer. The display shows a three-digit error code and brief message to identify any problem the printer may have. See the printer’s handbook for more information on the problem.
• Reset the Monarch printer. See the printer’s handbook for more information.
Use the Working with Price Tag Types (WPTY) menu option to configure the different types of price tags. CWSerenade is delivered with 9 different types of price tags:
Contact your MICROS representative if you would like to configure a new price tag type.
Assigning a Price Tag Type to an Item
Use the Tag Type field on the Change or Create Item Screen to assign a price tag type to an item.
You can also assign a price tag type to an item using the ITM Tag Type in the RI Item Upload table; see Working with Retail Integration Item Upload (RIIU).
In addition, the information in the following fields may print on the price tag, depending on the price tag type assigned to the item:
On the Change or Create Item Screen:
• L/S dept (Long SKU Department)
• L/S class (Long SKU Class)
• Season
• L/S vendor (Long SKU Vendor)
On the Create Item (Base Information) Screen (non-SKUed item) or Change or Create SKU 1 of 2 (With Overrides) Screen screen (SKUed item):
• List price (this price represents the regular price of the item on the price tag)
• SKU element 1 (SEO code)
• SKU element 2 (SEW code)
• SKU element 3 (SET code)
On the Work with UPC Codes Screen: UPC Code for the UPC Type defined in the Default UPC Type for Slotting New Items (L84) system control value.
On the Change or Create Item Offer Screen: the Price for the offer whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date. This price represents the sale price of the item on the price tag.
Price Tag Batch # Number Assignment Value
Use the Price Tag Batch # number assignment to assign the next sequence number to the PTG Batch # field in the Price Tag Batch table when a new price tag batch is created.
Define the order type that prints price tags during pick slip generation in the Order Type to Print Price Tags during Pick Generation (M28) system control value.
The Create/Change Price Tags (J09) secured feature controls which users have authority to create a price tag batch and add an item to an existing price tag batch in Working with Price Tags (WPTG).
• Allow = the user can create a price tag batch and add an item to an existing price tag batch in Work with Price Tags (WPTG).
• Exclude = the user cannot create a price tag batch or add an item to an existing price tag batch in Work with Price Tags (WPTG). The system displays an error message when the user selects Create on the Work with Price Tags screen or Work with Price Tag Detail screen: Not Authorized to Create Price Tag Batch.
The PPT Purge Printed Price Tags (program name PFPPT) periodic function allows you to purge price tag batches in the Price Tag Batch table that are in a P Printed status.
The system uses the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value to determine which UPC code to print on the price tag.
The Price Tag Data Mapping table contains the information required to print the data on the price tag correctly. This table is delivered with the information required to print the delivered price tags; see Delivered Price Tag Types.
Data Element |
Source Field / Table |
2 |
The ITM Number from the Item table. |
3 |
The SEW code (SKU element 2) from the SKU table. |
5 |
The Price from the Item Price table whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date. This price represents the sale price of the item on the price tag. |
6 |
The UPC from the Item UPC table for the UPC Type defined in the Default UPC Type for Slotting New Items (L84) system control value. |
7 |
The LSD Department from the Item table. |
8 |
The Long SKU Class from the Item table. |
9 |
The SEO code (SKU element 1) from the SKU table. |
10 |
The Long SKU Vendor from the Item table. |
11 |
The Season from the Item table. |
12 |
The SET code (SKU element 3) from the SKU table. |
13 |
The List Price from the SKU table. This price represents the regular price of the item on the price tag. |
The following price tags are delivered with CWSerenade. The default location used to store label formats is C:\CWSerenade\LabelFormats, where C: is the root drive where CWSerenade is installed. This location contains the base CWSerenade label formats and any unique label formats that have been defined.
Before you can use the delivered price tag types, you must:
• define each label type in the CSV Files section of the Price Tag Properties.
• use the Working with Price Tag Types (WPTY) menu option to define the printer used to print each price tag type.
Delivered price tag types:
Price tag type 1 labels are 1.2" wide x 2.2" high.
In order to print a price tag type 1 label:
• the MON_CSV_FILE1 property must contain the location on the CWSerenade application server where the MON01_label.csv file is located. The contents of this file determine the information that prints on the price tag type 1 label and how the information is presented on the label.
• a printer ID must be defined in the Printer Name field for price tag type 1 in Working with Price Tag Types (WPTY); this printer ID must be defined under the Window Service - Printer Names properties.
• records must exist in the Price Tag Data Mapping table for price tag type 1. This table contains the information required to print the data on the price tag correctly.
Price Tag Data Mapping Table |
Label Name on Price Tag |
CWSerenade Source Field / Table |
||
Tag Type |
Field # |
Element # |
||
1 |
1 |
7 |
DEPT |
LSD Department / Item |
1 |
2 |
8 |
CL |
Long SKU Class / Item |
1 |
3 |
9 |
CLR |
SEO code (SKU element 1) / SKU |
1 |
4 |
10 |
VEND |
Long SKU vendor / Item |
1 |
5 |
11 |
SEASON |
ITM SEA Season / Item |
1 |
6 |
2 |
STYLE |
ITM Number / Item |
1 |
7 |
3 |
SIZE |
SEW code (SKU element 2) / SKU |
1 |
8 |
12 |
DIM |
SET code (SKU element 3) / SKU |
1 |
9 |
13 |
REG. PRICE |
List Price / SKU |
1 |
10 |
5 |
SALE PRICE |
Price / Item Price, whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date |
1 |
11 |
6 |
unlabeled barcode |
UPC / Item UPC, using the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value |
Contents:
• CLEARANCE displays at the top of the label.
• DEPT: The long SKU department defined for the item in the Item table.
• CL: The long SKU class defined for the item in the Item table.
• CLR: The SEO code (SKU element 1) defined for the SKU in the SKU table.
• VEND: The long SKU vendor defined for the item in the Item table.
• SEASON: The season code defined for the item in the Item table.
• UPC barcode (unlabeled field below VEND and SEASON): The UPC code defined for the item in the Item UPC table. The system uses the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value to determine which UPC code to use.
• STYLE: The item number assigned to the item in the Item table.
• SIZE: The SEW code (SKU element 2) defined for the SKU in the SKU table.
• DIM: The SET code (SKU element 3) defined for the SKU in the SKU table.
• REG. PRICE: The list price defined for the item in the SKU table.
• SALE PRICE: The item offer price defined for the item whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date.
Price tag type 2 labels are 1.2" wide x 2.2" high.
In order to print a price tag type 2 label:
• the MON_CSV_FILE2 property must contain the location on the CWSerenade application server where the MON02_label.csv file is located. The contents of this file determine the information that prints on the price tag type 2 label and how the information is presented on the label.
• a printer ID must be defined in the Printer Name field for price tag type 2 in Working with Price Tag Types (WPTY); this printer ID must be defined under the Window Service - Printer Names properties.
• records must exist in the Price Tag Data Mapping table for price tag type 2. This table contains the information required to print the data on the price tag correctly.
Price Tag Data Mapping Table |
Label Name on Price Tag |
CWSerenade Source Field / Table |
||
Tag Type |
Field # |
Element # |
||
2 |
1 |
7 |
DEPT |
LSD Department / Item |
2 |
2 |
8 |
CL |
Long SKU Class / Item |
2 |
3 |
9 |
CLR |
SEO code (SKU element 1) / SKU |
2 |
4 |
10 |
VEND |
Long SKU vendor / Item |
2 |
5 |
11 |
SEASON |
ITM SEA Season / Item |
2 |
6 |
2 |
STYLE |
ITM Number / Item |
2 |
7 |
3 |
SIZE |
SEW code (SKU element 2) / SKU |
2 |
8 |
12 |
DIM |
SET code (SKU element 3) / SKU |
2 |
9 |
13 |
REG. PRICE |
List Price / SKU |
2 |
10 |
5 |
SALE PRICE |
Price / Item Price, whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date |
2 |
11 |
6 |
unlabeled barcode |
UPC / Item UPC, using the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value |
Contents:
• Your company name displays at the top of the label.
• DEPT: The long SKU department defined for the item in the Item table.
• CL: The long SKU class defined for the item in the Item table.
• CLR: The SEO code (SKU element 1) defined for the SKU in the SKU table.
• VEND: The long SKU vendor number defined for the item in the Item table.
• SEASON: The season code defined for the item in the Item table.
• UPC barcode (unlabeled field below VEND and SEASON): The UPC code defined for the item in the Item UPC table. The system uses the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value to determine which UPC code to use.
• STYLE: The item number assigned to the item in the Item table.
• SIZE: The SEW code (SKU element 2) defined for the SKU in the SKU table.
• DIM: The SET code (SKU element 3) defined for the SKU in the SKU table.
• REG. PRICE: The list price defined for the item in the SKU table.
• SALE PRICE: The item offer price defined for the item whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date.
Price tag type 3 labels are 1 1/4" wide x 3/4" high.
In order to print a price tag type 3 label:
• the MON_CSV_FILE3 property must contain the location on the CWSerenade application server where the MON03_label.csv file is located. The contents of this file determine the information that prints on the price tag type 3 label and how the information is presented on the label.
• a printer ID must be defined in the Printer Name field for price tag type 3 in Working with Price Tag Types (WPTY); this printer ID must be defined under the Window Service - Printer Names properties.
• records must exist in the Price Tag Data Mapping table for price tag type 3. This table contains the information required to print the data on the price tag correctly.
Price Tag Data Mapping Table |
Label Name on Price Tag |
CWSerenade Source Field / Table |
||
Tag Type |
Field # |
Element # |
||
3 |
1 |
3 |
STYLE |
ITM Number / Item |
3 |
2 |
12 |
SIZE |
SEW code (SKU element 2) / SKU |
3 |
3 |
5 |
PRICE |
List Price / SKU |
Contents:
• Your company name displays at the top of the label.
• STYLE: The item number assigned to the item in the Item table.
• SIZE: The SEW code (SKU element 2) defined for the SKU in the SKU table.
• PRICE: The list price defined for the item in the SKU table.
Price tag type 20 labels are 2" wide x 1 9/16" high.
In order to print a price tag type 20 label:
• the MON_CSV_FILE20 property must contain the location on the CWSerenade application server where the MON20_label.csv file is located. The contents of this file determine the information that prints on the price tag type 20 label and how the information is presented on the label.
• a printer ID must be defined in the Printer Name field for price tag type 20 in Working with Price Tag Types (WPTY); this printer ID must be defined under the Window Service - Printer Names properties.
• records must exist in the Price Tag Data Mapping table for price tag type 20. This table contains the information required to print the data on the price tag correctly.
Price Tag Data Mapping Table |
Label Name on Price Tag |
CWSerenade Source Field / Table |
||
Tag Type |
Field # |
Element # |
||
20 |
1 |
10 |
VEND |
Long SKU vendor / Item |
20 |
2 |
11 |
SEASON |
ITM SEA Season / Item |
20 |
3 |
9 |
CLR |
SEO code (SKU element 1) / SKU |
20 |
4 |
2 |
STYLE |
ITM Number / Item |
20 |
5 |
3 |
SIZE |
SEW code (SKU element 2) / SKU |
20 |
6 |
12 |
DIM |
SET code (SKU element 3) / SKU |
20 |
7 |
13 |
PRICE |
Price / Item Price, whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date |
20 |
8 |
6 |
unlabeled barcode |
UPC / Item UPC, using the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value |
Contents:
• Your company name displays at the top of the label.
• VEND: The long SKU vendor number defined for the item in the Item table.
• SEASON: The season code defined for the item in the Item table.
• CLR: The SEO code (SKU element 1) defined for the SKU in the SKU table.
• UPC barcode (unlabeled field below VEND and SEASON): The UPC code defined for the item in the Item UPC table. The system uses the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value to determine which UPC code to use.
• STYLE: The item number assigned to the item in the Item table.
• SIZE: The SEW code (SKU element 2) defined for the SKU in the SKU table.
• DIM: The SET code (SKU element 3) defined for the SKU in the SKU table.
• PRICE: The item offer price defined for the item whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date.
Price tag type 40 labels are 1 1/4" wide x 3/4" high.
In order to print a price tag type 40 label:
• the MON_CSV_FILE40 property must contain the location on the CWSerenade application server where the MON40_label.csv file is located. The contents of this file determine the information that prints on the price tag type 40 label and how the information is presented on the label.
• a printer ID must be defined in the Printer Name field for price tag type 40 in Working with Price Tag Types (WPTY); this printer ID must be defined under the Window Service - Printer Names properties.
• records must exist in the Price Tag Data Mapping table for price tag type 40. This table contains the information required to print the data on the price tag correctly.
Price Tag Data Mapping Table |
Label Name on Price Tag |
CWSerenade Source Field / Table |
||
Tag Type |
Field # |
Element # |
||
40 |
1 |
3 |
STYLE |
ITM Number / Item |
40 |
2 |
2 |
PRICE |
Price / Item Price, whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date |
40 |
3 |
6 |
unlabeled barcode |
UPC / Item UPC, using the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value |
Contents:
• STYLE: The item number assigned to the item in the Item table.
• UPC barcode (unlabeled field below VEND and SEASON): The UPC code defined for the item in the Item UPC table. The system uses the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value to determine which UPC code to use.
• PRICE: The item offer price defined for the item whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date.
Price tag type 50 labels are 2" wide x 3.1" high.
In order to print a price tag type 50 label:
• the MON_CSV_FILE50 property must contain the location on the CWSerenade application server where the MON50_label.csv file is located. The contents of this file determine the information that prints on the price tag type 50 label and how the information is presented on the label.
• a printer ID must be defined in the Printer Name field for price tag type 50 in Working with Price Tag Types (WPTY); this printer ID must be defined under the Window Service - Printer Names properties.
• records must exist in the Price Tag Data Mapping table for price tag type 50. This table contains the information required to print the data on the price tag correctly.
Price Tag Data Mapping Table |
Label Name on Price Tag |
CWSerenade Source Field / Table |
||
Tag Type |
Field # |
Element # |
||
50 |
1 |
7 |
DEPT |
LSD Department / Item |
50 |
2 |
8 |
CL |
Long SKU Class / Item |
50 |
3 |
9 |
CLR |
SEO code (SKU element 1) / SKU |
50 |
4 |
10 |
VEND |
Long SKU vendor / Item |
50 |
5 |
2 |
STYLE |
ITM Number / Item |
50 |
6 |
3 |
SIZE |
SEW code (SKU element 2) / SKU |
50 |
7 |
12 |
DIM |
SET code (SKU element 3) / SKU |
50 |
8 |
13 |
SUGG. PRICE |
List Price / SKU |
50 |
9 |
5 |
PRICE |
Price / Item Price, whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date |
50 |
10 |
6 |
unlabeled barcode |
UPC / Item UPC, using the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value |
Contents:
• DEPT: The long SKU department defined for the item in the Item table.
• CL: The long SKU class defined for the item in the Item table.
• CLR: The SEO code (SKU element 1) defined for the SKU in the SKU table.
• VEND: The long SKU vendor number defined for the item in the Item table.
• UPC barcode (unlabeled field below VEND and SEASON): The UPC code defined for the item in the Item UPC table. The system uses the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value to determine which UPC code to use.
• STYLE: The item number assigned to the item in the Item table.
• SIZE: The SEW code (SKU element 2) defined for the SKU in the SKU table.
• DIM: The SET code (SKU element 3) defined for the SKU in the SKU table.
• SUGG. PRICE: The list price defined for the item in the SKU table.
• PRICE: The item offer price defined for the item whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date.
Price tag type 60 labels are 2" wide x 1 9/16" high.
In order to print a price tag type 60 label:
• the MON_CSV_FILE60 property must contain the location on the CWSerenade application server where the MON60_label.csv file is located. The contents of this file determine the information that prints on the price tag type 60 label and how the information is presented on the label.
• a printer ID must be defined in the Printer Name field for price tag type 60 in Working with Price Tag Types (WPTY); this printer ID must be defined under the Window Service - Printer Names properties.
• records must exist in the Price Tag Data Mapping table for price tag type 60. This table contains the information required to print the data on the price tag correctly.
Price Tag Data Mapping Table |
Label Name on Price Tag |
CWSerenade Source Field / Table |
||
Tag Type |
Field # |
Element # |
||
60 |
1 |
10 |
VEND |
Long SKU vendor / Item |
60 |
2 |
11 |
SEASON |
ITM SEA Season / Item |
60 |
3 |
9 |
CLR |
SEO code (SKU element 1) / SKU |
60 |
4 |
2 |
STYLE |
ITM Number / Item |
60 |
5 |
3 |
SIZE |
SEW code (SKU element 2) / SKU |
60 |
6 |
12 |
DIM |
SET code (SKU element 3) / SKU |
60 |
7 |
13 |
COMPARE AT |
List Price / SKU |
60 |
8 |
5 |
PRICE |
Price / Item Price, whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date |
60 |
9 |
6 |
unlabeled barcode |
UPC / Item UPC, using the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value |
Contents:
• Your company name displays at the top of the label.
• VEND: The long SKU vendor number defined for the item in the Item table.
• SEASON: The season code defined for the item in the Item table.
• CLR: The SEO code (SKU element 1) defined for the item in the SKU table.
• UPC barcode (unlabeled field below VEND and SEASON): The UPC code defined for the item in the Item UPC table. The system uses the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value to determine which UPC code to use.
• STYLE: The item number assigned to the item in the Item table.
• SIZE: The SEW code (SKU element 2) defined for the item in the SKU table.
• DIM: The SET code (SKU element 3) defined for the item in the SKU table.
• COMPARE AT: The list price defined for the item in the SKU table.
• PRICE: The item offer price defined for the item whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date.
Price tag type 65 labels are 2 9/16" wide x 5/8" high.
In order to print a price tag type 65 label:
• the MON_CSV_FILE65 property must contain the location on the CWSerenade application server where the MON65_label.csv file is located. The contents of this file determine the information that prints on the price tag type 65 label and how the information is presented on the label.
• a printer ID must be defined in the Printer Name field for price tag type 65 in Working with Price Tag Types (WPTY); this printer ID must be defined under the Window Service - Printer Names properties.
• records must exist in the Price Tag Data Mapping table for price tag type 65. This table contains the information required to print the data on the price tag correctly.
Price Tag Data Mapping Table |
Label Name on Price Tag |
CWSerenade Source Field / Table |
||
Tag Type |
Field # |
Element # |
||
65 |
1 |
6 |
STYLE |
Item number / Item |
65 |
2 |
2 |
PRICE |
Price / Item Price, whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date |
65 |
3 |
8 |
DEPT |
LSD Department / Item |
65 |
4 |
7 |
CL |
Long SKU Class / Item |
65 |
5 |
11 |
SEASON |
ITM SEA Season / Item |
65 |
6 |
10 |
VEND |
Long SKU vendor / Item |
65 |
7 |
3 |
unlabeled barcode |
UPC / Item UPC, using the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value |
Contents:
• PRICE: The item offer price defined for the item whose Offer Number matches the offer number defined in the Current Offer (A33) system control value and whose Effective date is less than or equal to the current date.
• UPC barcode (unlabeled field below VEND and SEASON): The UPC code defined for the item in the Item UPC table. The system uses the UPC type defined in the Default UPC Type for Slotting New Items (L84) system control value to determine which UPC code to use.
• CL: The long SKU class defined for the item in the Item table.
• DEPT: The long SKU department code defined for the item in the Item table.
• SEASON: The season code defined for the item in the Item table.
• VEND: The long SKU vendor number defined for the item in the Item table.
• STYLE: The item number assigned to the item in the Item table.
Price Tags | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Working with Price Tag Types (WPTY) |
WH17_01 OROMS 5.0 2018 OTN