Navigate to Add New Products from the left sidebar.
Click Download Template.
The Pharmx template will be downloaded to your Downloads folder.
Save the template to your preferred location on your computer, then open it to begin adding your product information.
5. Complete the template by entering the required details for each product. Refer to
the table below for guidance on completing each field accurately.
6. Before proceeding with the upload, double-check for missing values, formatting
errors, and invalid characters.
7. Save the file.
8. For guidance on how to upload your file, refer to ‘Add Products’ Guide.
PRODUCT FIELDS
Please see the following overview of all product template fields.
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 list price (ex 10% GST) | The price, excluding GST, at which the product will be sold to pharmacies | Numeric value without the $ symbol | 7.5 |
GST Code (Y / N / F) | The tax rate or exemption applied to the product | Populated as one of the following bold characters: Y - GST F - GST free N - No GST Detailed guidelines for GST code are available below. | N |
RRP (Optional) | The RRP, including GST This represents the price that the supplier recommends retailers sell the product for | Optional field Numeric value without the $ symbol | 15 |
Product code | Unique identifier assigned to the product by the supplier |
| PHARMX123 |
MOQ | The minimum order quantity for the product. | Numeric value greater than or equal to 1 | 1 |
PDE SIGMA | The Sigma PDE Code for the product | Leave blank if product is not fulfilled by Sigma | 234567 |
PDE SYMBION | The Symbion PDE Code for the product | Leave blank if product is not fulfilled by Symbion | 234567 |
PDE API | The API PDE Code for the product | Leave blank if product is not fulfilled by API | 234567 |
PDE CH2 | The CH2 PDE Code for the product | Leave blank if product is not fulfilled by CH2 | 234567 |
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 |
Example:
GUIDELINES FOR ALLOCATING GST CODES
This guide explains the different GST codes and how to assign them correctly for
product catalogue maintenance and order processing.
Below are the guidelines for allocating GST Codes to a product:
GST (Y): The product is subject to GST for suppliers, retailers, and end customers.
GST free (F): The product is subject to GST for suppliers and retailers but is GST-free for end customers.
No GST (N): The product is exempt from GST.
To help you better understand how to allocate GST Codes, here are some examples:
GST Code | GST paid by suppliers/retailers | GST paid by end-customers | Product Examples |
GST (Y) | Yes | Yes |
|
GST free (F) | Yes | No |
|
No GST (N) | No | No |
|
TEMPLATES
See the example product file below for reference, then use the blank template to fill in your own product details.