Import Purchases

Modified on Wed, 25 Oct 2023 at 05:10 PM

Biztory is able to create multiple purchases at the same time using the import feature. Kindly follow the steps below to import the purchases.


1) Click My Biztory on the right top

2) 

  • Click the 3rd Party App to view the features and ensure the CSV Import is ticked. 
  • Click Purchases tab
  • Click Download Sample CSV to view the required data need to prepare 
  • Click Upload CSV then select the Purchases sample CSV


    3) Preview the data, click Import button then purchases will be prepare to import.

    4) Sample expected result after imported  


    Data definitions 
    1. ref_num - Purchase invoice number
    2. invoice_date - Date of the invoice
    3. payee - Customer name
    4. total - Total per item (Same as Amount)
    5. email - Customer email address
    6. phone - Customer contact number
    7. billing_addr - Customer billing address, (please put "-" if don't have a billing address.)
    8. payment_term - Default Cash only
    9. sst_supply_date - SST supply date (Key in invoice_date if don't have SST supply date)
    10. code - Item code (Act as SKU code)
    11. description - Description of item.
    12. tax_value - Example 6% = 0.06, (if no tex value please put "0")
    13. qty - Quantity per item
    14. unit - Unit per item
    15. price - Price of item
    16. total_tax - Formula = (qty *  price) * tax_value
    17. tax_label - Type of tax, (please put "TX-0 " if don't have any tax

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article