Large Corporate ordering Systems - How do we import orders in a CSV file from large companies with many stores placing orders.

Question

Hi There 
 How do we import orders in a CSV file from large companies with many stores placing orders? 
 We get their output in a very nice CSV file but no way to import it... surely we cannot be capturing mnaually form a CSV into Sage Sales order per client per store... 
 Any idea tip or integration 
 Current CSV is from Pick n Pay but shortly expect them from SPAR and Checkers too... 
 
 thanks 
 thomas

Nteboheleng William M. · Answer

Hey 
 Does the following help? 
 
 Go to File --> Export in P/O Purchase Order Entry . 
 Select the type of file you want in File Type. Specify the file name and the location you want to save the file to. 
 In the List in the Export file, users can select which fields they want to include in their import file. The fields with the red star are the required fields in each tab that we must include. 
 After users select the fields they want to include on the import template, they can also select Save Script at the bottom of the screen. This allows users to create a script containing these settings for importing and exporting records for future use. More information about this function and how to use it in the "Saving and Loading Scripts" in F1 help menu. 
 Then, after all the settings are set, click OK to generate the import template. 
 Input your information on the export file. When the file is ready, go to File --> Import in P/O Purchase Order Entry for import. 
 Select the file from the location and click OK for import.

Sage 300cloud

Large Corporate ordering Systems - How do we import orders in a CSV file from large companies with many stores placing orders.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING