Import/Export Select Product Info
A way to import/export select product information. We put product on sale at the end of the year and every year we have to go thru each individual size and each price category and assign a beginning date and end date to them. This equals to over 8,000 places where we change this information.
There are a few scenarios for which we are requested to handle product imports. We provide professional services to our clients to help address any data needs, including product imports/updates, and one of our team will contact you to help with this. For example, we've assisted some of our clients with producing a spreadsheet of product data that they can manipulate in Excel and then we can import the changes back into CMS.
That said, this type of request does come up enough that we would like to develop a formalized solution in CMS if we can get enough interest expressed (votes).
For prospective voters, I will list the various product import scenarios below. Please comment here if you have others, which apply to you, or other related comments.
*a new install of CMS - desire to import products from web site or old order management system
*a new product list received from a vendor - Creating new products and updating existing products (should there be an option to not update existing products, skipping those and only creating new ones?)
*internal pricing/product changes - very similar to the above but you're working with a spreadsheet of your own product data to facilitate efficient bulk changes and, when complete, import back into CMS