Austlink Help Centre

Follow

Jiwa Inventory - Price Updates: Import From Excel

In this article we will look at how inventory prices and costs can be updated using the Jiwa Price Update - Import From Excel function.

 

NOTE: 

Before using this feature it is highly recommended that you test your import file in your Test or Training database before attempting to complete the update in your live database.

 

Preparing Your Import File

Before importing our updates we need to first prepare our import file.

Your file only needs to include the part number and the price you want to update.

In the example below the default supplier cost will be updated however the current cost has been included in the file for comparison purposes only.  The current cost will not be imported.

Save your file.

 

Importing Cost Price Updates

Select Inventory > Utilities > Price Updates > Import from Excel

 

Select your required ranges, in this example Clothing products will be updated.

Select the spreadsheet you want to use for the update.

Use the icon next to the Spreadsheet File field to browse to your file.

Set your required import fields

Price

Select the price to be updated

Note: If updating your supplier cost price then select the option Supplier FX Cost.  Only the cost for the default supplier and warehouse will be updated.

Sheet Specify the sheet from the file to be used
Part No. Column Specify the column number in the sheet that contains the part number
Price Column Specify the column number in the sheet that contains the price column to use
Start Row Specify the first row to the import sheet to start at
End Row Specify the last row in the import sheet to end at
Part No. Is Supplier Part No. When ticked indicates that the part number contained the part number field is the supplier part number

 

When you are ready select Process to complete you update.

 

The process status bar will be updated when the update has been completed.

 

This video is best seen on the full screen. Just click on the icon at the bottom right of the video (see image below).

To exit full screen just press escape 

 

VideoFullScreen.jpg

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

This entire document, including design, text, videos,graphics, and photographs are Copyright © 2014 Austlink Plus Pty Ltd, All Rights Reserved.
No part of this document may be reproduced in any way or by any means for commercial or any other purposes, without prior written permission of Austlink Plus Pty Ltd. Use of any data for the purpose of creating promotional materials or producing a printed or electronic catalog of any kind is expressly forbidden without prior written permission of Austlink Plus Pty Ltd.

Powered by Zendesk