More problems with suzuki price files.

Latest price file Suzuki have published has structural modifications in it which they did not alert c9 to, nor do they ever give us the opportunity to quality control the file before they make it available on their website. 🙁

The problem is manually priced items.  Luckily it can be fixed with a bit of fussing about. C9 will look at making changes to allow c9 to cope with the changes, making sure it is able to import either format, but it will not be ready at least until Monday morning.

Manually priced items are hidden in a xls spreadsheet in the suzuki file.

Originally, and for years the file looked like this:

As of now it now contains a new column and daily and stock lines are back-to-front:

To fix this without updating c9,  you need to unzip the ZIP file provided by suzuki to extract the Manual Priced Items MC.xlsx file and then you import the xlsx file a second time using Generic method. Generally to extract file you can right click on the .zip file in windows and select 'Extract To..'.

Generic config I believe should work. One issue though is that in xls file  Suzuki are not using convention of RRP = list price + GST for all the parts, in their file RRP is a bit all over the place.  so I am unsure which column should be imported here.  Sticking with how file worked originally, I am tentatively recommending using list price (Retail ex GST), but it is quite possible that RRP in this file is Suzuki's recommended, manually set price. Ultimately a question for them to answer.