HOW TO EDIT THE CSV DOCUMENT
Any CSV parts list downloaded from TOPIx must be edited before being uploaded to Retailer Parts Ordering System (RPOS).
- Delete any part numbers and data that is not required.
-
Fill in the cells as follows:
- Cell A1 Title should be the Importer Account Code
- Cell B1 Title should be the Importer Ship to for specific retailer
- Cell C1 Title should be the importer order reference
- Column A2 Onwards is the part number, with 02 or 28 as the prefix. 02 for Jaguar vehicles and 28 for Land Rover vehicles
- Column B is the order quantity
- Column C onwards is the retailer reference
- The final CSV file should look similar to this:
- When you have updated the CSV parts list save it.
The final CSV file should look similar to the image shown above.
UPLOADING THE CSV PART LIST TO RPOS
The RPOS home page is red for Jaguar and green for Land Rover.
- Navigate to the RPOSHome Page
Retailer Parts Ordering System
and select the Home on the dropdown menu.
- Then select Ordering and then New Order.
- This will open the ordering page, select Upload File.
- Then select Stock Order or VOR Order.
- Select File to open the File Upload screen. Locate your saved CSV parts list and select Open.
- Select Upload File.
Process the File
- Select Process File. This will populate RPOS with details from the CSV parts list.
- Select Validate Order the RPOS system will check that there are no errors and display stock status.
- When validated and you are OK with the order select Submit Order.
- After the order is submitted order confirmation will be displayed, with Sales Order Number.