Hi,
I'm looking to change and update the product groups of all stock items we have on our system. Is this something that can be done by exporting and importing records, or would each product need changing one by one?
Thank you!
Hi,
I'm looking to change and update the product groups of all stock items we have on our system. Is this something that can be done by exporting and importing records, or would each product need changing one by one?
Thank you!
Hi,
Thank you for your question.
Yes, it is possible to export stock items, amend the product group on the resultant CSV file and then import the stock items back into Sage 200 whilst selecting the ‘Update stock record if it exists’ option to update their associated product groups.
This option will still be subject to the limitations outlined in the following help page:
Further guidance on Exporting and Importing data can be found in the following help page:
I recommend trying this on a test copy of your data and discussing this matter with your Sage support provider before attempting it on your live data.
Regards
Chris
Take a look at Excelerator for Sage 200:
https://www.youtube.com/watch?v=mXxwyx_3XEM
You can easily update and create Stock records in Sage 200 using Excel whilst being confident that the control and validation of Sage 200 is maintained.
*Community Hub is the new name for Sage City