Adding Products Into Purchase Orders Via Spreadsheets

Adding Products Into Purchase Orders Via Spreadsheets

When you need to add a lot of products into Stock Purchase Order, you can import and add products through Spreadsheet.


To start on, kindly navigate to: Inventory > Purchases > +Add New (as per the screenshot below)

After getting New Purchase Order screen, select “IMPORT ITEMS TO THIS ORDER”

You will get the pop-up screen as per below: There you can click on “download our import file template” & download the templte file.

Download the template and if you don’t know how to put item details, please go to your product list and put correct information in the spreadsheet.

As well as, if you want to update the cost of the poroducts in the purchase order, Please check the important note mentioned in the template. As mentioned in it, if you are going to change the cost, pleae enter data only in “New Cost” column in spreadsheet, if the item cost is different from the cost on the product list. If they are same, please keep “New Cost” & “Cost Change Type” blank.

Also, if you would like to update the cost of the products in the purchase order, please check the important note mentioned in the template. As mentioned in it, you will only need to enter data in the “New cost” field if the item cost is different from the cost on the product page. If they are the same, please keep “New cost” and “Cost change type" fields blank.

Please put “0,1 & 2” in the Cost Change Types as per follows.

0: Temporary Change- applies only to this PO

1: Permanent- Update Selling price with same profit margin

2: Permanent- Update Profit margin same selling price

Make sure you import the file upto 4MB.

It will import the products you updated in the spreadsheet.

You can view the import log which has been imported successfully from the spreadsheet.

While importing if you got any error, you can check the error log by selecting “View import log” as per the below screenshot and you can also download the error log file by selecting “Download records with error” and rectify from the downloaded spreadsheet.

You can correct the error in the downloaded file “records with error” & re-import the file so it will be imported successfully.

After importing all the records successfully, you can save the Purchase Order.

    • Related Articles

    • Adding new products via Purchase orders

      While you have options to create new products from product page manually or via excel file, you can also add new products into Hike via Purchase orders. There are two ways to add products via Purchase orders. We have a separate support article if you ...
    • Creating & Adding Products in Hike

      Your products are the lifeblood of your business, for obvious reasons, and the need to ensure you add each new item into your point-of-sale correctly, is essential. From customizable product tags and descriptions to setting up things like inventory ...
    • Importing Products via Excel Files

      When businesses are moving to Hike POS, rather than having to manually create all their data – products, customers & suppliers – it may be preferable to have all information stored onto a spreadsheet, that can then be imported into Hike. This ...
    • Export A Purchase Order

      In Hike, You can Export a Purchase Order into 4 different types as per you find it suitable. You can export ‘Opened Purchase Order’ & ‘Partially Received Purchase Order’ as per the following steps. Open the ‘Opened Purchase Order’ or ‘Partially ...
    • Adding Suppliers in Hike

      Suppliers are an integral part of any business that purchases goods from wholesale suppliers to stock in their store. Having a streamlined system to add, edit and delete suppliers where necessary, are features that your point-of-sale solution will ...