The Select-n-Load Inventory Pricing option allows for updating inventory prices for the selected inventory code and store combination. Use PaXcel functions to retrieve current pricing and standard Excel functions to increase pricing to create new or future prices.
The spreadsheet must contain the Inventory Code, Inventory Description, and Store code (001 if not multi-store). The following column headers can be used to update certain prices.
Use the Field Indicators below to indicate which prices need to be updated. Not all fields need to be included, allowing only certain prices to be loaded, for example, if you only want to update Exclusive selling prices one and two.
Details |
Field Indicator |
Details |
Field Indicator |
Inventory Code |
Inventory Code |
Future Exclusive |
Exclusive Future 01 |
Inventory Description |
Inventory Description |
|
Exclusive Future 02 |
Store Code |
Store |
|
Exclusive Future 03 |
Exclusive Price |
Exclusive 01 |
|
Exclusive Future 04 |
|
Exclusive 02 |
|
Exclusive Future 05 |
|
Exclusive 03 |
|
Exclusive Future 06 |
|
Exclusive 04 |
|
Exclusive Future 07 |
|
Exclusive 05 |
|
Exclusive Future 08 |
|
Exclusive 06 |
|
Exclusive Future 09 |
|
Exclusive 07 |
|
Exclusive Future 10 |
|
Exclusive 08 |
Future Inclusive |
Inclusive Future 01 |
|
Exclusive 09 |
|
Inclusive Future 02 |
|
Exclusive 10 |
|
Inclusive Future 03 |
Inclusive Price |
Inclusive 01 |
|
Inclusive Future 04 |
|
Inclusive 02 |
|
Inclusive Future 05 |
|
Inclusive 03 |
|
Inclusive Future 06 |
|
Inclusive 04 |
|
Inclusive Future 07 |
|
Inclusive 05 |
|
Inclusive Future 08 |
|
Inclusive 06 |
|
Inclusive Future 09 |
|
Inclusive 07 |
|
Inclusive Future 10 |
|
Inclusive 08 |
|
|
|
Inclusive 09 |
|
|
|
Inclusive 10 |
|
|
Special Price |
Exclusive Special |
Starting date |
Special From |
|
Inclusive Special |
Ending Date |
Special Until |
The example below will load future prices one, two and three for the selected inventory codes.
