Help please! Need tips for bulk editing prices overnight -- best practices

Site URL: https://www.phelpsrefinishing.com/

Need tips on best practices for an "overnight" price increase on over 400 products that takes effect on Jan. 1. The maximum prices are set by the manufacturer, so the prices can't change on the site till that date.

The site has 8 separate product pages, each with quite a few categories and of course, tags. Have studied the bulk editing directions, with concern about matching existing images. Also, many product descriptions include bullet lists, which the bulk edit directions say could cause the import to fail. There are probably hyperlinks as well. And some products are in more than one category (on the same page). A few products are duplicated on other pages but with different urls and 

All we need to change are the prices -- nothing else. It's a shame that the Inventory list says nothing about the product page. 

I have realized that I can make a copy of the site as it is before trying the bulk editing. Maybe do a test run on one page of the site copy. 

Would really appreciate tips because the timing is going to be short and it must work!

hi Catherine, 

Did you ever get any responses to this anywhere? Thanks!

Mark

Same situation here. 

Please, Squarespace! It would be so helpful to build a feature like this if you haven't already.  It is perhaps the single most important issue that makes me tempted to switch to Shopify.