Overview: Copying items allows you to:
• Copy item information from one item to a new item in the same company using the Copy Item Window.
• Create an item upload record to add, change or delete item information, for an item with the same item number as the copied item, in each shared company using the Copy Item to Company Window.
In this topic:
• Copy Item to Company Process
Purpose: Use this window to copy item information from one item to a new item in the same company.
Note: The system copies item information from the Item file and SKU file; any other files related to the item, such as Item Offer or Vendor Items, are not copied to the new item. Once the item is created, you can create additional item information for the item from the Work with Items Screen.
How to display this screen: Enter 3 next to an item on the Work with Items Screen.
Copy Item KAB Co
From Item: JPY1 ASIAN 16PC DINNERWARE: BLUE WAVE PATTERN
To Item. .
L/S Style.
F3=Exit F12=Cancel |
Field |
Description |
From item |
The item number and description of the item whose item information you wish to copy to a new item in the same company. Item number: Alphanumeric, 12 positions; display-only. Item description: Alphanumeric, 40 positions; display-only. |
The item number you wish to create, using the item information defined for the from item. An error message display if you enter an item number that already exists in the current company: Item already exists. Alphanumeric, 12 positions; required. |
|
(Unlabeled field to the right of the To item field.) A description of the newly created item. Alphanumeric, 40 positions; required. |
|
The long SKU style defined for the newly created item. Note: This field displays only if the Require L/S Style (I94) system control value is set to Y. An error message displays if you enter a long SKU style that is already assigned to another item: L/S Style must be unique. If the Require L/S Style (I94) system control value is set to N, the system copies the long SKU style from the copied item. Alphanumeric, 20 positions; required. |
Complete the following steps to copy item information from one item to a newly created item in the current company.
1. Enter the item number and description of the item you wish to create in the To item and To item description fields.
2. If the Require L/S Style (I94) system control value is set to Y, enter a unique long SKU style code in the L/S style field.
3. Press Enter. The system presents the current screen flow required to create an item and performs existing screen validation.
The screen flow varies, depending on whether you are creating a non-SKU’d item or SKU’d item. Additionally, the Item Creation Values (J08) umbrella system control value contains system control values that control which screens automatically display when you are creating an item.
Non-SKU’ed item screen flow: The system automatically advances you through the following screens if the item you are copying is a non-SKU’ed item.
1. Create Item Screen. The information on this screen defaults from the copied item; however, you can change any value.
2. Create Item (Base Information) Screen. The information on this screen defaults from the copied item; however, you can change any value.
3. Create Vendor Item Screen (only if the Auto Advance to Vendor Item Create (E78) system control value is set to Y). The information on this screen does not default from the copied item.
4. First Work with Keywords for Item Screen (only if the Create Keywords at Item Entry (F78) system control value is set to Y). The information on this screen does not default from the copied item.
5. Create Item Offer Screen (only if the Auto Advance to Item Offer (J05) system control value is set to Y). The information on this screen does not default from the copied item.
Once you have completed creating the item, based on copied item information, the system returns you to the Work with Items Screen.
SKU’ed item screen flow: The system automatically advances you through the following screens if the item you are copying is a SKU’ed item.
1. Create Item Screen. The information on this screen defaults from the copied item; however, you can change any value.
2. First Work with Keywords for Item Screen (only if the Create Keywords at Item Entry (F78) system control value is set to Y). The information on this screen does not default from the copied item.
3. Create Item Offer Screen (only if the Auto Advance to Item Offer (J05) system control value is set to Y). The information on this screen does not default from the copied item.
Once you have completed creating the item, the system returns you to the Work with Items Screen. Every SKU defined for the copied item is automatically created for the new item.
File updates: The system copies the Item record and SKU record when you copy item information from one item to a newly created item. However, the following fields are not copied.
• SKU file
Field |
Comments |
ITM number |
From the To item field on the Copy Item Window. |
Last phy date |
Remains blank. |
Last purchase cost |
Remains blank. |
Long SKU style |
If the Require L/S Style (I94) system control value is set to Y, from the L/S style field on the Copy Item Window. If the Require L/S Style (I94) system control value is set to N, defaults from copied item. |
Description |
From the To item description field on the Copy Item Window. |
Last change date |
Defaults to current date. |
Date last extract |
Remains blank. |
Last ecomm info chg |
Remains blank. |
Download processed |
Remains blank. |
Create date |
Defaults to current date. |
Updated by user |
Defaults to current user. |
Creation user |
Defaults to current user. |
Field |
Comments |
ITM number |
From the To item field on the Copy Item Window. |
SKU code |
The system copies all SKUs defined for the copied item to the newly created item. |
Last purchase cost |
Remains blank. |
Cub val |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
Height override |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
Length override |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
Makeup date |
Remains blank. |
Qty order direct ship |
Remains blank. |
Receipt date |
Remains blank. |
Out of stock date |
Remains blank. |
Selling weight override |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
Short SKU |
System generated unique number. |
Times out of stock |
Remains blank. |
Times picked |
Remains blank. |
Weight override |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
Width override |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
D.F.O. (date of first order) |
Remains blank. |
D.L.O. (date of last order) |
Remains blank. |
Orders avail pick gen |
Remains blank. |
SKU open qty |
Remains blank. |
Future qty |
Remains blank. |
Suspense qty |
Remains blank. |
On hold qty |
Remains blank. |
SKU average cost |
Defaults to the cost defined in the Cost field on the Create Item screen, not the cost defined for the copied item. |
Drop ship avail qty |
Remains blank. |
L/S style |
If the Require L/S Style (I94) system control value is set to Y, the system concatenates the item number + SKU code; for example ITEM RED WMNS SMLL. If the Require L/S Style (I94) system control value is set to N, defaults from copied item. |
Last download qty |
Remains blank. |
Last extract |
Remains blank. |
Last ecomm info chg |
Remains blank. |
Last changed date |
Remains blank. |
SKU create date |
Defaults to the current date. |
CTN ID # (SKU) |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
UOM |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
Element 1 |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
Element 2 |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
Element 3 |
Remains blank for non-SKU’ed items; copied for SKU’ed items. |
Purpose: Use this window to create an item upload record in the Retail Integration Item Upload File (RIIUPP) to add, change or delete item information, for an item with the same item number as the copied item, in each shared company.
Once the system creates the item upload record, the system follows regular Item Upload Processing to process the record. If the record contains errors, the system places the record in the Working with Retail Integration Item Upload (RIIU) menu option in the shared company where you can review, correct, and reprocess the record.
Copy Item to Company allows you to maintain inventory in the parent company and copy the item information over to your shared companies.
Example:
• When you create item A1 in the parent company, you can copy A1, including its offers, prices, UPC, coordinates, and vendor items, over to the shared companies.
• When you change item A1 in the parent company, you can copy the item updates to item A1 in the shared companies.
• When you delete item A1 in the parent company, you can select to delete the item from your shared companies.
How to display this screen: Enter 33 next to an item at the Work with Items Screen.
When you select this option:
• An error message indicates if you do not have authority to the Copy Item to Company Security (B15) secured feature: Not authorized to Copy.
• An error message indicates if shared companies do not exist for the current company: Shared companies do not exist for the parent. You can define shared companies for a company in Setting Up Companies (WCMP).
The system defaults the settings selected the last time the window was accessed; however, you can change the settings.
Copy Item to Company KAB Co
From Company: 555 From Item . : COPY COPY ITEM DESCRIPTION
Action to perform . . (A=Add,C=Change,D=Delete)
Select Record Types: Item/SKU. . . . . N (Y/N) Item Offer. . N (Y/N) SKU Offer . . . . N (Y/N) Item Price. . N (Y/N) SKU Price . . . . N (Y/N) Item UPC. . . N (Y/N) Item Coordinate . N (Y/N) Vendor Item . N (Y/N)
Shared Companies: 12 18 24 25 26 27 50 51 55 242 (+)
F3=Exit F9=Accept F12=Cancel F19=Shared Companies |
Field |
Description |
From company |
A code for the company where the copied item is located. This represents a parent company that is associated with one or more shared companies. Numeric, 3 positions; display-only. |
From item |
The item number and description of the copied item. Item number: Alphanumeric, 12 positions; display-only. Item description: Alphanumeric, 40 positions; display-only. |
Indicates the type of item upload record you wish to create in the Retail Integration Item Upload File (RIIUPP). A = The system creates an item upload record with a Request type of A (add), indicating the system creates the item information in the shared company. C = The system creates an item upload record with a Request type of C (maintain), indicating the system updates the item information in the shared company. D = The system creates an item upload record with a Request type of D (delete), indicating the system deletes the item information from the shared company. Alphanumeric, 1 position; required. |
|
|
You must specify the type of item information you wish to populate in the item upload record, using the item information defined for the copied item, by entering Y in at least one of the following fields. For each record type selected, the system copies the item information from the copied item and creates an item upload record for each shared company. • Item/SKU • Item UPC If you do not select at least one of the record type fields, an error message displays: At least one record type required. Example: If you wish to create the copied item in each shared company, enter A in the Action to perform field and enter Y in each Record type field. The system will copy all item information for the copied item and create the item in each shared company. Note: The system does not validate that the record type you select to copy exists for the copied item. If the selected item information does not exist, the system submits the Copy Item to Company process, but does not create an item upload record for that record type. |
|
Indicates whether the system creates an item upload record for record type 01 (item/SKU) in the Retail Integration Item Upload File (RIIUPP) for each shared company, using the item/SKU information defined for the copied item. Y = The system creates a record in the Retail Integration Item Upload File (RIIUPP) for record type 01 (item/SKU) for each shared company, using the item/SKU information defined for the copied item. See Item upload records created for record type Item/SKU for more information on the type of item upload record created, based on the action code and record type selected, and the expected results in the shared company. N = Do not create a record in the Retail Integration Item Upload File (RIIUPP) for record type 01 (item/SKU). Alphanumeric, 1 position; required. |
|
Indicates whether the system creates an item upload record for record type 03 (item offer) in the Retail Integration Item Upload File (RIIUPP) for each shared company, using the item offer information defined for the copied item. Y = The system creates a record in the Retail Integration Item Upload File (RIIUPP) for record type 03 (item offer) for each shared company, using the item offer information defined for the copied item. See Item upload records created for record type Item Offer for more information on the type of item upload created, based on the action code and record type selected, and the expected results in the shared company. N = Do not create a record in the Retail Integration Item Upload File (RIIUPP) for record type 03 (item offer). Alphanumeric, 1 position; required. |
|
Indicates whether the system creates an item upload record for record type 04 (SKU offer) in the Retail Integration Item Upload File (RIIUPP) for each shared company, using the SKU offer information defined for the copied item. Y = The system creates a record in the Retail Integration Item Upload File (RIIUPP) for record type 04 (SKU offer) for each shared company, using the SKU offer information defined for the copied item. See Item upload records created for record type SKU Offer for more information on the type of item upload created, based on the action code and record type selected, and the expected results in the shared company. N = Do not create a record in the Retail Integration Item Upload File (RIIUPP) for record type 04 (SKU offer). Alphanumeric, 1 position; required. |
|
Indicates whether the system creates an item upload record for record type 05 (item price) in the Retail Integration Item Upload File (RIIUPP) for each shared company, using the item price information defined for the copied item. Y = The system creates a record in the Retail Integration Item Upload File (RIIUPP) for record type 05 (item price) for each shared company, using the item price information defined for the copied item. See Item upload records created for record type Item Price for more information on the type of item upload created, based on the action code and record type selected, and the expected results in the shared company. N = Do not create a record in the Retail Integration Item Upload File (RIIUPP) for record type 05 (item price). Alphanumeric, 1 position; required. |
|
Indicates whether the system creates an item upload record for record type 06 (SKU price) in the Retail Integration Item Upload File (RIIUPP) for each shared company, using the SKU price information defined for the copied item. Y = The system creates a record in the Retail Integration Item Upload File (RIIUPP) for record type 06 (SKU price) for each shared company, using the SKU price information defined for the copied item. See Item upload records created for record type SKU Price for more information on the type of item upload created, based on the action code and record type selected, and the expected results in the shared company. N = Do not create a record in the Retail Integration Item Upload File (RIIUPP) for record type 06 (SKU price). Alphanumeric, 1 position; required. |
|
Indicates whether the system creates an item upload record for record type 08 (item UPC) in the Retail Integration Item Upload File (RIIUPP) for each shared company, using the item UPC information defined for the copied item. Y = The system creates a record in the Retail Integration Item Upload File (RIIUPP) for record type 08 (item UPC) for each shared company, using the item UPC information defined for the copied item. See Item upload records created for record type Item UPC for more information on the type of item upload created, based on the action code and record type selected, and the expected results in the shared company. N = Do not create a record in the Retail Integration Item Upload File (RIIUPP) for record type 08 (item UPC). Alphanumeric, 1 position; required. |
|
Indicates whether the system creates an item upload record for record type 09 (item coordinate) in the Retail Integration Item Upload File (RIIUPP) for each shared company, using the item coordinate information defined for the copied item. Y = The system creates a record in the Retail Integration Item Upload File (RIIUPP) for record type 09 (item coordinate) for each shared company, using the item coordinate information defined for the copied item. See Item upload records created for record type Item Coordinate for more information on the type of item upload created, based on the action code and record type selected, and the expected results in the shared company. N = Do not create a record in the Retail Integration Item Upload File (RIIUPP) for record type 09 (item coordinate). Alphanumeric, 1 position; required. |
|
Indicates whether the system creates an item upload record for record type 07 (vendor item) in the Retail Integration Item Upload File (RIIUPP) for each shared company, using the vendor item information defined for the copied item. Y = The system creates a record in the Retail Integration Item Upload File (RIIUPP) for record type 07 (vendor item) for each shared company, using the vendor item information defined for the copied item. See Item upload records created for record type Vendor Item for more information on the type of item upload created, based on the action code and record type selected, and the expected results in the shared company. N = Do not create a record in the Retail Integration Item Upload File (RIIUPP) for record type 07 (vendor item). Alphanumeric, 1 position; required. |
|
Shared companies |
The shared companies for which the system will create an item upload record, based on the action code and record types selected. Up to 10 shared companies display in company number sequence. A plus sign (+) displays if more shared companies exist. You can press F19 to view a complete list of the shared companies for which an item upload record will be created. Numeric, 3 positions; display-only. |
Screen Option |
Procedure |
Submit the copy item to company process to create item upload records in the Retail Integration Item Upload File (RIIUPP) for each shared company, based on the action code and record types selected |
Press F9. The system returns you to the Work with Items Screen with a message similar to the following: Copy Item To Company program has been submitted to batch. See Copy Item to Company Process for the steps the system performs. |
Review a list of shared companies for which the system will create an item upload record, based on the action code and record types selected |
Press F19 to advance to the Shared Companies window. Note: You cannot add, change, or delete shared companies at this window. You can define shared companies for a company in Setting Up Companies (WCMP). |
Instructions: Complete the following steps to create an item upload record in the Retail Integration Item Upload File (RIIUPP) to add, change or delete item information, for an item with the same item number as the copied item, in each shared company, based on the action code and record types selected at the Copy Item to Company Window.
1. In the Action to perform field, indicate the type of item activity you wish to perform.
• A = The system creates an item upload record with a Request type of A (add), indicating the system creates the item information in the shared company.
• C = The system creates an item upload record with a record type of C (maintain), indicating the system updates the item information in the shared company.
• D = The system creates an item upload record with a record type of D (delete), indicating the system deletes the item information from the shared company.
2. Enter Y in the record types you wish to create. This represents the item information you wish to create, update, or delete, based on the specified action code. See:
• Item upload records created for record type Item/SKU
• Item upload records created for record type Item Offer
• Item upload records created for record type SKU Offer
• Item upload records created for record type Item Price
• Item upload records created for record type SKU Price
• Item upload records created for record type Item UPC
• Item upload records created for record type Item Coordinate
• Item upload records created for record type Vendor Item
3. Press F9. The system returns you to the Work with Items Screen with a message similar to the following: Copy Item To Company program has been submitted to batch.
Note: If you select to delete, the system displays a Delete Confirmation window, verifying that you wish to delete the item information. Press F9 to continue with Copy to Company processing; otherwise, press F3 or F12 to cancel.
Delete Confirmation
You have selected the Delete process which will delete this item from all Shared Companies. Do you wish to continue?
F3=Exit F9=Continue F12=Cancel |
4. The system creates item upload records in the Retail Integration Item Upload File (RIIUPP), based on the action code and record types selected. Each item upload record is created with:
• A Key type of IT (item/SKU), indicating the system identifies the item in the shared company using the Item and SKU fields in the item upload record. The Copy Item to Company program populates these fields with the item number and optionally, SKU code, defined for the copied item.
• A Status of U (unprocessed), indicating the item upload record is ready to be processed.
5. Once the Copy Item to Company program has created all of the item upload records, the system automatically submits the Item Upload process to process the records in the Retail Integration Item Upload File (RIIUPP).
6. The Item Upload process:
• Reads all records in the Retail Integration Item Upload File (RIIUPP) that are in a U or blank status.
• Identifies the item/SKU based on the Key type field.
7. The system processes item upload records in order based on earliest date and time. If the date and time for multiple records are the same, the system starts with record type 01 and continues in record type sequence. If there are both add and change records for the same item, the system processes the add records first. Note: If item upload records already exist in the Retail Integration Item Upload File (RIIUPP), the system processes those records along with the records created through the Copy Item to Company program.
8. If the Create Supporting Files during Retail Item Upload (H27) system control value is set to Y in the shared company, the system creates supporting file values for items/SKUs through the item upload. For example, if the buyer code does not exist in the shared company, the system creates it. The system creates supporting file values in the following files if the value does not exist in the shared company:
• SKU Element 1
• SKU Element 2
• SKU Element 3
• Item Warehouse
• Item Location
• Item Class
• Item Status
• Buyer
• L/S Department
• L/S Class
• L/S Division
• Retail Class
• Item Category
• Prep Code
9. The system places any records that contain errors in an error status in the Retail Integration Item Upload File (RIIUPP) and Retail Integration Item Upload Error file. You can review the records in error on the Item Upload Error Report and on the Work with Retail Item Upload Errors Screen in Working with Retail Integration Item Upload (RIIU). See Retail Item Upload Errors for a list of errors that may occur.
Note: Item upload records in error display in the Work with Retail Integration Item Upload (RIIU) menu option in the shared company, not the company where the copied item is located. For example, if you create the copied item in shared companies 100 and 200 and both item upload records error, you must review and correct the item upload record in error in each shared company (companies 100 and 200).
10. Once the Item Upload process completes, the system generates the following reports:
• Item Upload Processed Records Report: Indicates that item upload records passed all edits, and the updates were made.
• Item Upload Error Report: Indicates that item upload records failed one or more edits and remain in the Retail Integration Item Upload file.
• Record Deleted from RI Item Upload Report: Indicates that you deleted the item upload record(s) from the Retail Integration Item Upload file by entering 4 next to an item upload record at the Work with Retail Item Upload Screen. This means that the edit program did not create, maintain, or delete any item/SKU information.
The table below indicates the type of item upload record created, based on the action code and record type selected.
Action / Record type |
Item Upload Record Created |
A Item/SKU |
The item upload record contains: • Record type 01 (item/SKU), indicating the system populates the item and SKU fields in the item upload record using the item/SKU information defined for the copied item. See Fields for 01 Item/SKU Record Type for a list of the fields populated. • Request type A (add), indicating the system creates the item in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. Note: If the item already exists in the shared company, the system automatically changes the Request type to C (maintain). Short SKU: The system generates a new short SKU code for each item/SKU created in the shared company. |
|
**DFLT ITEM: If a field for the copied item is blank, the system creates the item upload record and leaves the field blank. However, if **DFLT ITEM exists as an item in the shared company, the system defaults the value defined for the **DFLT ITEM item to the blank field in the item upload record. For example, if the buyer code is blank from the copied item, but the **DFTL ITEM contains buyer code BTM, the system defaults BTM to the item upload record and creates the item in the shared company with buyer code BTM. See Creating the **DFLT ITEM Item/SKU for more information on setting up this item. Item Upload Processing Results The system creates an item/SKU in each shared company, using the item number and item/SKU information from the copied item. If the copied item contains SKUs, the system creates a SKU for each SKU defined for the copied item. Note: When creating a new item, the program does not use the Locate elig (Locate eligible) setting from the **DFLT ITEM record; this field is always set to Y for a new item. |
C Item/SKU |
The item upload record contains: • Record type 01 (item/SKU), indicating the system populates the item and SKU fields in the item upload record using the item/SKU information defined for the copied item. See Fields for 01 Item/SKU Record Type for a list of the fields populated. • Request type C (maintain), indicating the system updates the item in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the item does not exist, the system updates the item upload record to an error status. Short SKU: The system retains the short SKU defined for the item in the shared company instead of updating the short SKU with the short SKU defined for the copied item. **DFLT ITEM item: If a field for the copied item is blank, the system creates the item upload record and leaves the field blank. However, if **DFLT ITEM exists as an item in the shared company, the system defaults the value defined for the **DFLT ITEM item to the blank field in the item upload record. For example, if the buyer code is blank from the copied item, but the **DFTL ITEM contains buyer code BTM, the system defaults BTM to the item upload record and updates the item in the shared company with buyer code BTM. See Creating the **DFLT ITEM Item/SKU for more information on setting up this item. |
|
**DFTCHG item: If **DFTCHG exists as an item in the shared company, the system looks to this item to determine if the item in the shared company should be updated with the information from the copied item. • If a field in the **DFTCHG item is populated, the system does not update the item in the shared company with the value from the copied item. • If a field in the **DFTCHG item is blank, the system updates the item in the shared company with the value from the copied item. Example: If the copied item has buyer code TWB and the item in the shared company has buyer code BTM, the system will retain buyer code BTM if the **DFTCHG item has a buyer code defined. However, if the Buyer code field for the **DFTCHG item is blank, the system updates the buyer code for the item in the shared company to TWB. See Creating the **DFTCHG Item/SKU for more information on setting up this item. Item Upload Processing Results In each shared company, the system updates the item/SKU with the same item number as the copied item, using the item/SKU information from the copied item. |
D Item/SKU |
The item upload record contains: • Record type 01 (item/SKU), indicating the system populates the item and SKU fields in the item upload record using the item/SKU information defined for the copied item. See Fields for 01 Item/SKU Record Type for a list of the fields populated. • Request type D (delete), indicating the system deletes the item in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. Note: If you select to delete the item, the system ignores the setting for all other record types since the item/SKU will be deleted in the shared companies. Item Upload Processing Results In each shared company, the system deletes the item/SKU with the same item number as the copied item. |
A Item Offer |
The item upload record contains: • Record type 03 (item offer), indicating the system populates the item offer fields in the item upload record using the item offer information defined for the copied item. See Fields for 03 Item Offer Record Type for a list of the fields populated. • Request type A (add), indicating the system creates the item offer in the shared company. If the copied item contains SKUs, the system creates one item upload record for the main item only. If the item offer already exists in the shared company, the system automatically changes the Request type to C (maintain). Item Upload Processing Results In each shared company, the system creates item offers for the item with the same item number as the copied item, using the item offers from the copied item. |
C Item Offer |
The item upload record contains: • Record type 03 (item offer), indicating the system populates the item offer fields in the item upload record using the item offer information defined for the copied item. See Fields for 03 Item Offer Record Type for a list of the fields populated. • Request type C (maintain), indicating the system updates the item offer in the shared company. If the copied item contains SKUs, the system creates one item upload record for the main item only. If the item offer does not exist in the shared company, the system updates the item upload record to an error status. Item Upload Processing Results In each shared company, the system updates the item offer(s) for the item with the same item number as the copied item, using the item offer information from the copied item. |
D Item Offer |
The item upload record contains: • Record type 03 (item offer), indicating the system populates the item offer fields in the item upload record using the item offer information defined for the copied item. See Fields for 03 Item Offer Record Type for a list of the fields populated. • Request type D (delete), indicating the system deletes the item offer in the shared company. If the copied item contains SKUs, the system creates one item upload record for the main item only. Note: If you select to delete the item offer, the system ignores the setting for the item price record type since the item offer and item price will be deleted in the shared companies. Item Upload Processing Results In each shared company, the system deletes the item offer(s) for the item with the same item number as the copied item, using the item offer(s) defined for the copied item. For example, if the copied item has 2 offers: 100 and 200, but the item in the shared company has 3 offers: 100, 200, and 300, the system will only delete offers 100 and 200. |
A SKU Offer |
The item upload record contains: • Record type 04 (SKU offer), indicating the system populates the SKU offer fields in the item upload record using the SKU offer information defined for the copied item. See Fields for 04 SKU Offer Record Type for a list of the fields populated. • Request type A (add), indicating the system creates the SKU offer in the shared company. The system creates a separate item upload record for each item/SKU. If the SKU offer already exists in the shared company, the system automatically changes the Request type to C (maintain). Note: In order to create an item upload record for Record type 04, the copied item must contain SKUs. If the item is a non-SKU’d item, the system automatically deletes the item upload record and displays it on the Record Deleted from RI Item Upload Report. Item Upload Processing Results In each shared company, the system creates SKU offers for the item with the same item number as the copied item, using the SKU offers from the copied item. |
C SKU Offer |
The item upload record contains: • Record type 04 (SKU offer), indicating the system populates the SKU offer fields in the item upload record using the SKU offer information defined for the copied item. See Fields for 04 SKU Offer Record Type for a list of the fields populated. • Request type C (maintain), indicating the system updates the SKU offer in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the SKU offer does not exist, the system updates the item upload record to an error status. Item Upload Processing Results In each shared company, the system updates the SKU offer(s) for the item with the same item number as the copied item, using the SKU offer information from the copied item. |
D SKU Offer |
The item upload record contains: • Record type 04 (SKU offer), indicating the system populates the SKU offer fields in the item upload record using the SKU offer information defined for the copied item. See Fields for 04 SKU Offer Record Type for a list of the fields populated. • Request type D (delete), indicating the system deletes the SKU offer in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If you select to delete the SKU offer, the system ignores the setting for the SKU price record type since deleting the SKU offer will automatically delete the SKU price in the shared companies. Item Upload Processing Results In each shared company, the system deletes the SKU offer(s) for the item with the same item number as the copied item, using the SKU offer(s) defined for the copied item. For example, if the copied item has 2 offers: 100 and 200, but the item in the shared company has 3 offers: 100, 200, and 300, the system will only delete offers 100 and 200. |
A Item Price |
The item upload record contains: • Record type 05 (item price), indicating the system populates the item price fields in the item upload record using the item price information defined for the copied item. See Fields for 05 Item Price Record Type for a list of the fields populated. • Request type A (add), indicating the system creates the item price in the shared company. If the copied item contains SKUs, the system creates one item upload record for the main item only for each item price. If the item price already exists in the shared company, the system automatically changes the Request type to C (maintain). Item Upload Processing Results In each shared company, the system creates item prices for the item with the same item number as the copied item, using the item prices from the copied item. |
C Item Price |
The item upload record contains: • Record type 05 (item price), indicating the system populates the item price fields in the item upload record using the item price information defined for the copied item. See Fields for 05 Item Price Record Type for a list of the fields populated. • Request type C (maintain), indicating the system updates the item price in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the item price does not exist, the system updates the item upload record to an error status. Item Upload Processing Results In each shared company, the system updates the item price(s) for the item with the same item number as the copied item, using the item price information from the copied item. |
D Item Price |
The item upload record contains: • Record type 05 (item price), indicating the system populates the item price fields in the item upload record using the item price information defined for the copied item. See Fields for 05 Item Price Record Type for a list of the fields populated. • Request type D (delete), indicating the system deletes the item price in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. Item Upload Processing Results In each shared company, the system deletes the item price(s) for the item with the same item number as the copied item, using the item price(s) defined for the copied item. |
A SKU Price |
The item upload record contains: • Record type 06 (SKU price), indicating the system populates the SKU price fields in the item upload record using the SKU price information defined for the copied item. See Fields for 06 SKU Price Record Type for a list of the fields populated. • Request type A (add), indicating the system creates the SKU price in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the SKU price already exists in the shared company, the system automatically changes the Request type to C (maintain). Item Upload Processing Results In each shared company, the system creates SKU prices for the item with the same item number as the copied item, using the SKU prices from the copied item. |
C SKU Price |
The item upload record contains: • Record type 06 (SKU price), indicating the system populates the SKU price fields in the item upload record using the SKU price information defined for the copied item. See Fields for 06 SKU Price Record Type for a list of the fields populated. • Request type C (maintain), indicating the system updates the SKU price in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the SKU price does not exist, the system updates the item upload record to an error status. Item Upload Processing Results In each shared company, the system updates the SKU price(s) for the item with the same item number as the copied item, using the SKU price information from the copied item. |
D SKU Price |
The item upload record contains: • Record type 06 (SKU price), indicating the system populates the SKU price fields in the item upload record using the SKU price information defined for the copied item. See Fields for 06 SKU Price Record Type for a list of the fields populated. • Request type D (delete), indicating the system deletes the SKU price in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. Item Upload Processing Results In each shared company, the system deletes the SKU price(s) for the item with the same item number as the copied item, using the SKU price(s) defined for the copied item. |
A Item UPC |
The item upload record contains: • Record type 08 (item UPC), indicating the system populates the item UPC fields in the item upload record using the item UPC information defined for the copied item. See Fields for 08 Item UPC Record Type for a list of the fields populated. • Request type A (add), indicating the system creates the item UPC in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the item UPC already exists in the shared company, the system automatically changes the Request type to C (maintain). Item Upload Processing Results In each shared company, the system creates item UPCs for the item with the same item number as the copied item, using the item UPCs from the copied item. |
C Item UPC |
The item upload record contains: • Record type 08 (item UPC), indicating the system populates the item UPC fields in the item upload record using the item UPC information defined for the copied item. See Fields for 08 Item UPC Record Type for a list of the fields populated. • Request type C (maintain), indicating the system updates the item UPC in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the item UPC does not exist, the system updates the item upload record to an error status. Item Upload Processing Results In each shared company, the system updates the item UPC(s) for the item with the same item number as the copied item, using the item UPC information from the copied item. |
D Item UPC |
The item upload record contains: • Record type 08 (item UPC), indicating the system populates the item UPC fields in the item upload record using the item UPC information defined for the copied item. See Fields for 08 Item UPC Record Type for a list of the fields populated. • Request type D (delete), indicating the system deletes the item UPC in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. Item Upload Processing Results In each shared company, the system deletes the item UPC(s) for the item with the same item number as the copied item, using the item UPC(s) defined for the copied item. |
A Item Coordinate |
The item upload record contains: • Record type 09 (item coordinate), indicating the system populates the item coordinate fields in the item upload record using the item coordinate information defined for the copied item. See Fields for 09 Item Coordinate Record Type for a list of the fields populated. • Request type A (add), indicating the system creates the item coordinate in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the item coordinate already exists in the shared company, the system automatically changes the Request type to C (maintain). Item Upload Processing Results In each shared company, the system creates item coordinates for the item with the same item number as the copied item, using the item coordinates from the copied item. |
C Item Coordinate |
The item upload record contains: • Record type 09 (item coordinate), indicating the system populates the item coordinate fields in the item upload record using the item coordinate information defined for the copied item. See Fields for 09 Item Coordinate Record Type for a list of the fields populated. • Request type C (maintain), indicating the system updates the item coordinate in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the item coordinate does not exist, the system updates the item upload record to an error status. Item Upload Processing Results In each shared company, the system updates the item coordinate(s) for the item with the same item number as the copied item, using the item coordinate information from the copied item. |
D Item Coordinate |
The item upload record contains: • Record type 09 (item coordinate), indicating the system populates the item coordinate fields in the item upload record using the item coordinate information defined for the copied item. See Fields for 09 Item Coordinate Record Type for a list of the fields populated. • Request type D (delete), indicating the system deletes the item coordinate in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. Item Upload Processing Results In each shared company, the system deletes the item coordinate(s) for the item with the same item number as the copied item, using the item coordinate(s) defined for the copied item. |
A Vendor Item |
The item upload record contains: • Record type 07 (vendor item), indicating the system populates the vendor item fields in the item upload record using the vendor item information defined for the copied item. See Fields for 07 Vendor Item Record Type for a list of the fields populated. • Request type A (add), indicating the system creates the vendor item in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the item coordinate already exists in the shared company, the system automatically changes the Request type to C (maintain). Item Upload Processing Results In each shared company, the system creates vendor items for the item with the same item number as the copied item, using the vendor items from the copied item. |
C Vendor Item |
The item upload record contains: • Record type 07 (vendor item), indicating the system populates the vendor item fields in the item upload record using the vendor item information defined for the copied item. See Fields for 07 Vendor Item Record Type for a list of the fields populated. • Request type C (maintain), indicating the system updates the vendor item in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. If the vendor item does not exist, the system updates the item upload record to an error status. Item Upload Processing Results In each shared company, the system updates the vendor item(s) for the item with the same item number as the copied item, using the vendor item information from the copied item. |
D Vendor Item |
The item upload record contains: • Record type 07 (vendor item), indicating the system populates the vendor item fields in the item upload record using the vendor item information defined for the copied item. See Fields for 07 Vendor Item Record Type for a list of the fields populated. • Request type D (delete), indicating the system deletes the vendor item in the shared company. If the copied item contains SKUs, the system creates a separate item upload record for each item/SKU. Item Upload Processing Results In each shared company, the system deletes the vendor item(s) for the item with the same item number as the copied item, using the vendor item(s) defined for the copied item. |
| Working with Item Coordinate Types (WICT) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Reviewing Item/SKU Cost History |
ME03_14 CWDirect 18.0.x 2018 OTN