Export Stocks, Make Changes, then Import Stocks back in

1. Do a backup first. Do it after hours or on the weekend when no one else is logged in. (Don’t do it during business hours.)

2. Try it with a small batch of about 10 stocks first so you get an idea of what results you will get. Export the stocks using the attached report.

3. Make your changes in Excel and save as CSV. Import them back into PS with the Import Stock Catalog feature. Use the GENERIC interpreter. PS will only accept a (.CSV) Comma Separated File

4. PS will only recognize stocks with a Stock # (No stock # = no luck)

5. If you mess it up you can always revert to your backup.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s