Exporting and Importing Customer Contract Prices

Please ensure that you do not modify contract prices whilst exporting and importing the spreadsheet.

Run these processes on your Server!

Pages
Exporting Customer Contract Prices To An Excel Spreadsheet
Importing Customer Contract Prices From Excel to Readysell

Exporting Customer Contract Prices Into An Excel Spreadsheet

From the Readysell Main Menu

Click on report <Report Wizard>

If you don't get the new report writer screen as pictured below, you would be on the old report window, click on <Report Wizard> (bottom right hand corner of the screen)

New report writer

Search for Type = 'Customer'

Description = 'Contract Prices All Customers'

Click on <Run Highlighted Report>

<Close> query for all contract prices for all customers

Report will display to screen

Click on <Send To>

Select Excel and Save it to folder D:\Rsello\ContractPrices.XLS (If this is the correct path for your Readysell. It may even be D:\READYSELL\RSELLO\Contract Prices.xls This is should be run on your server)

The process generates the report (you do not have to do anything with this screen)

The Excel spreadsheet then opens. Commence EDITING ONLY THE DATA AND SAVE IT WITH THE SAME NAME. DO NOT ADD, CHANGE OR DELETE ANY POSITIONS OR COLUMNS. MAKE SURE YOU DO NOT CHANGE COLUMNS AT ALL. ONLY CHANGE THE DATA

Once you have made your data changes and <Save> the file as noted in point 9.

If you wanted to change start and end dates
Excel stuffs this up as it wants to save dates in its own internal date format.
You need to highlight, then format the start and end date columns as text to make Excel save them back in the correct format.
You could then change the dates and import them back.

Importing The Customer Contract Prices Excel Spreadsheet Back Into Readysell

Go back to the Readysell Main Menu

Select <Import> Module

Highlight name 'Contact Prices All Customers' and click on <Change>

Check the Input File = 'Contractprices.XLS'

Click on <GO>

This process will read the rows and then update the data file.

Check the import by checking couple of customers.

That is it.
Note :-

Some columns can't be changed,
Some columns can be changed as you like,
The date columns have to be formatted as text if you want to change them.

Browser not supported