Skip to end of metadata
Go to start of metadata



QUESTION:I have a large number of existing product codes that I need to update their product information. Is there a way that I can mass import the product info and therefore save time?

ANSWER:

An Information Import exists in ProStix. By default it expects the filename prod_info.csv with the following data format:

product code, line 1 comment, line 2 comment, line 3 comment, line 4 comment, line 5 comment, line 6 comment, line 7 comment, line 8 comment, line 9 comment, line 10 comment

The product code is limited to 15 characters maximum

Each comment line is limited to 40 characters maximum

A sample prod_info.csv file can be downloaded via the following link:

prod_info.csv

Once you have the prod_info.csv file created and ready, save it across to the Linux production server that hosts ProStix and save it under the /prostix/dmp directory

Note: Most customers have a Windows Mapped Network drive that points to the /prostix/dmp directory so can either drag and drop or copy and paste the file to /prostix/dmp

To import the prod_info.csv file, perform the following:

1. Select menu options System Administration - Utilities - System File Imports - Product Info Import . Press <F1> to run the import.

2. The import will run and when completed the screen will return to the System File Imports menu

The File Location will by default be populated with /prostix/dmp/prod_info.csv

The File location can be edited if filename is different or the path to the file is different to the default.

IF THIS FAQ DOESN’T RESOLVE YOUR ISSUE:

Contact Sterland Support.