Hi Mike/Mods, thanks for taking the time to reply.
The actual working company file we have online, cannot import price changes if sales exist, but allows "new" items to be created - almost the direct oppisite of what is required, very frustrating as the items we are selling are not getting price changes and prices have increased several times just in the last few months to point our sell pricing is way under buy pricing.
The company file has been migrated from Prem 19.6 been reduced in size had a lot of adjustments eg culled over 120k items last year, so while it does not import correctly, there may indeed be underlying issues we are unaware about.
The business is machinery and repairs industry, so parts catalog and pricing is supplier based, the importing is to match supplier codes as well as preset prices.
I have personally burnt and wasted many hours/days trying to import correctly, had another person also try for a full day, reached out for a consultant but cannot even book one in our area.
The owner is so desperate they are try to update as many prices by hand as they can just to stop the better sellers from bleeding him dry.
BUT using the clearwater file.
However having the same errors and a brand new "clearwater" local libary sample file used for sanity testing just makes no sense at all. The most basic test was to export all items, leaving no fields out, open in excel manually changed every price by hand - no formula etc. Then import that file back in and producing the same errors - there must be something going on that causes this. The sample file cannot also have file errors?
Anyway our comany file serial ends in 2677, is number 1 and is online.
Once scripted/repaired I can test with a couple of items and will know within a few mins if imported works or not.
Regards
mcfproservices.