Preparing your CSV file
Download the CSV template:
Navigate to the Products section from the sidebar and select Add New.
In the pop-up dialog, click the Get a template button to download the CSV template.
Open and edit the CSV template using your preferred editor:
Complete the template by filling in the required details for each product.
Refer to the table below for guidance on completing the product details accurately.
Save the file:
Ensure the file is saved in the .CSV format.
Double-check for missing values, formatting errors and invalid characters proceeding with the upload.
Field Name | Field Description | Field Requirements | Field Example |
Product barcode | Barcode on the pack of the individual unit | Maximum 14 digits | 9123456789000 |
Product brand | Brand name of the product |
| Pharmx |
Product name | Full name of the product, including brand name | Maximum 50 characters | Pharmx Pain Relief 500mg Tablets 100 |
Product code | Unique identifier assigned to the product by the supplier |
| PHARMX123 |
Currency (AUD/NZD) | Currency in which the product is sold—either Australian dollars (AUD) or New Zealand dollars (NZD). | Populated as either AUD or NZD | AUD |
Product list price (ex 10% GST) | The price, excluding GST, at which the product will be sold to pharmacies | Numeric value without the $ symbol | 7.50 |
GST Code (Y / N / F). GST (Y),"No GST (N)", "GST-free (F)" | The tax rate or exemption applied to the product | Populated as one of the following bold characters:
Detailed guidelines for GST code are available here | N |
Product list price (including 10% GST) | The price, including GST, at which the product will be sold to pharmacies | Numeric value without the $ symbol | 8.25 |
RRP (Optional) | The RRP, including GST
This represents the price that the supplier recommends retailers sell the product for | Optional field | 15 |
Order Multiples | The quantity representing the multiples in which the item must be ordered | Numeric value greater than or equal to 1 | 1 |
Product Schedule (1-9) | Schedule of the product, as classified under the Poisons Standard in Australia | Populated as one of the following values: S01, S02, S03, S04, S05, S06, S07, S08, S09.
For further details on each value, refer to the Product Schedule table provided below. | S03 |
Product Category | Product category assigned by the supplier, based on primary function and/or characteristics |
| Medicine |
Product sub-category | A more specific classification within the category, as defined by the supplier |
| Pain Relief |
Description (optional), max 300 characters | Additional product information that will be visible to pharmacies | Optional field
Maximum 300 characters | Pharmx Pain Relief Tablets provide effective relief from minor aches and pains. |
The table below provides the values and corresponding descriptions for the Product Schedule field:
Product Schedule Value | Product Schedule | Description |
S01 | Unscheduled | No poison schedule classification (E.g. Cosmetics) |
S02 | Schedule 2 | Pharmacy Medicine |
S03 | Schedule 3 | Pharmacist Only Medicine |
S04 | Schedule 4 | Prescription Only Medicine OR Prescription Animal Remedy |
S05 | Schedule 5 | Caution |
S06 | Schedule 6 | Poison |
S07 | Schedule 7 | Dangerous Poison |
S08 | Schedule 8 | Controlled Drug |
S09 | Schedule 9 | Prohibited Substance |
Uploading your CSV file
Navigate to the Products section from the sidebar and select Add New.
Click the Import CSV button located on the right side of the dialog box:
On the next page, click the Add CSV file + button to proceed:
Select the CSV file you wish to upload.
On the next page, you can either:
Proceed with the upload:
Tick either Overwrite products or Skip duplicates based on your preference.
Click the Upload and Review button.
Replace the file (optional):
If you selected the wrong file and want to start over, click the Replace File button to upload a new CSV file.
Carefully review the product details on the review page.
Check for common errors, such as:
Missing or incorrect headings
Missing columns
Incorrect values entered
Exceeding character limits
To edit a product before publishing, click the Action button (three vertical dots) located on the right-hand side.
If you are satisfied with all the product details, click the Publish x products button (where X is the total number of products uploaded).
Once published, the products will appear in your product catalogue.
Managing products after upload
Click here for the detailed guide on how to edit or archive products after uploading.