Product Catalogue Import
Your product catalogue should be delivered as a spreadsheet or CSV with the following information.
| Column Name | Data Type | Description | Example |
| Pharmacode | Text (max 40) | Product Unique ID | 123456 |
| GTIN Barcode* | GTIN Barcode | GINT Barcode Format | 12345678901231 |
| Name* | Text (max 100) | Product Name | Coffee Mug |
| Images* | List of image paths* | Names of images separated by semi-colons | image1.jpg;image2.jpg |
| Description* | HTML | Description of product | This is a <b>fantastic</b> product. |
| Sales Restriction* | Pharmacist Only, Pharmacy Only, Unrestricted | The type of product from a sales restriction point of view | Unrestricted |
| Classification* | A classification code for the product based on the GPC standard | See classifications later in this document | 51160000 |
| Supplier | Text (max 100) | The product’s supplier | ABC Supplier |
| Brand | Text (max 100) | The product’s brand | Nike |
| Unit type | Text (max 50) | Type of unit, if applicable | mg |
| Units | Number | Number of units, if applicable | 100 |
| Cart Limit | Number | Max number of products can be sold in a single transaction | 1 |
| Tags | List of text tags | Tags associated with the product to help with filtering | cup;red |
| RRP | Money | RRP unit price of the product. | 9.99 |
| Url | Text (max 100) | A URL for the product | coffee-mug |
| Page Title | Text | Page title used for search engine optimisation | Coffee Mug - Carl's Emporium |
| Page Description | Text | Page description used for search engine optimisation | The Best Coffee Mug available on the market today |
| Keywords | Text | Keywords used for search engine optimisation | Coffee,Mug,Cup,Drink,Hot |
HTML Description Guide
The product description can be supplied in HTML format although a limited number of formatting options are permitted. This allows the formatting preferences of the displaying pharmacy site to be honoured.
it is important that the description contains all the information required to meet any New Zealand compliance regulations for display and sale (if applicable) of the product on the public internet. This is the responsibility of the supplier.
Example Description
About ABC Product
Ut nec quam non purus luctus pellentesque. Donec fringilla dui ut nulla vestibulum malesuada. Pellentesque id dapibus arcu. Mauris ac elementum elit. Vivamus sed euismod lorem, et lacinia ante. Donec fringilla faucibus odio eu tincidunt. Quisque a neque non magna faucibus placerat. Etiam eget elit ex. Vestibulum molestie arcu sit amet vulputate scelerisque. Phasellus vel pellentesque urna. In aliquam risus odio, id pretium ipsum tincidunt a. Aliquam mollis sem eget magna venenatis placerat eu in ligula. Donec vitae commodo felis, eget feugiat elit.
Common Uses
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed ut quam vel dui rhoncus molestie non sed sem. Aliquam rutrum congue erat sit amet feugiat. Vivamus lacus lorem, dapibus sed arcu in, efficitur consectetur urna. Donec consectetur urna et augue facilisis, quis accumsan dui congue. Proin maximus sagittis velit id blandit. Nunc vitae ipsum vel velit dignissim consequat. Phasellus maximus finibus arcu, vitae semper mi sodales eu. Nunc et ullamcorper dolor. Nam porttitor lorem nec malesuada interdum. Ut ornare odio ut erat accumsan lacinia et vel risus. Morbi ultricies ac orci pellentesque tristique. Nam volutpat elementum dignissim. Mauris ultrices fermentum leo, eget tristique lorem porta sit amet. Nulla ut risus at lectus molestie interdum dapibus id dui. Integer quam justo, porta eget est id, feugiat interdum est. Integer elementum mi dignissim, tempus arcu non, aliquet neque.
Suggested Dose
Adults: Take 1 daily.
Best taken before bed, on an empty stomach or as directed by your Healthcare Professional.
Ingredients Per Dose
- Ingredient 1
- Ingredient
Safety Information
Etiam at pharetra nisl. Etiam eget orci condimentum, sagittis sem eget, sodales nisl. Duis fermentum felis ipsum, ut suscipit arcu varius vitae. Sed placerat tellus nisi, ac sodales mi consequat nec. Donec in dignissim dui. In placerat, felis non lobortis gravida, diam tortor lobortis mi, sit amet gravida justo sem quis neque. Pellentesque ac commodo ante. Curabitur diam tortor, vulputate sed justo ut, lacinia bibendum lectus.
Aliquam in metus dignissim, tincidunt tortor eget, vestibulum ante. Quisque in diam pharetra purus dictum hendrerit vel at ipsum.
HTML Guide
Example
The above description’s HTML would be as follows:
<h2>About ABC Product</h2>
<p>Ut nec quam non purus <b>luctus pellentesque</b>. ...</p>
<h2>Common Uses</h2>
<p>Lorem ipsum dolor sit amet, ...</p>
<h2>Suggested Dose</h2>
<p>Adults: Take 1 daily.</p>
<p>Best taken before bed, on an empty ...</p>
<h2>Ingredients Per Dose</h2>
<ul>
<li>Ingredient 1</li>
<li>Ingredient 1</li>
</ul>
<h2>Safety Information</h2>
<p>Etiam at pharetra nisl. Etiam eget ...</p>
Allowed HTML Tags
The following paragraph tags are allowed:
- p*
- h2*
- h3
if you would like the text to display larger than normal, add a class attribute with the value ‘large’ ie. <p class="large" />
Note: h1 is not permitted. This is because it is reserved for the product’s name which is automatically displayed on the product’s page.
The following inline character style elements are allowed: - •u •b •i
- strong
- em
- ol
- li
- ul
- a (href, name and target attributes allowed)
- br
Product images should be supplied in JPG or PNG format in original high resolution. The images should preferably be clear cut without padding.
It is important that the name of the image precisely matches the name specified in the product catalogue import file.
Classifications
The following GPC classification codes are related top healthcare:
| Code | Name |
| 51111500 | Barrier Contraception |
| 51111600 | Hormonal Contraception |
| 51111700 | Intra-uterine Contraception |
| 51111800 | Family Planning Variety Packs |
| 51121500 | Dietary Aids |
| 51121600 | Vitamins/Minerals/Nutritional Supplements |
| 51121800 | Health Enhancement Variety Packs |
| 51121900 | Energy/Stimulant Products |
| 51131500 | Diagnostic Monitors |
| 51131600 | Diagnostic Tests |
| 51131700 | Home Diagnostics Variety Packs |
| 51140100 | Healthcare Variety Packs |
| 51150100 | Medical Devices |
| 51160100 | Pharmaceutical Drugs |
| 51170100 | Veterinary Pharmaceuticals |
| 51170200 | Veterinary Medical Devices |
| 53131100 | Skin Care |
| 53131200 | Skin Tanning Products |
| 53131300 | Body Washing |
| 53131400 | Skin Products Variety Packs |
| 53141000 | Hair Removal/Masking Products |
| 53141100 | Hair Care Products |
| 53141200 | Hair Products Variety Packs |
| 53161000 | Cosmetic Products |
| 53161200 | Nail Cosmetic/Care Products |
| 53161300 | Fragrances |
| 53161400 | Cosmetics/Fragrances Variety Packs |
| 53161500 | Aromatherapy |
| 53181100 | General Personal Hygiene |
| 53181200 | Feminine/Nursing Hygiene |
| 53181300 | Adult Incontinence |
| 53181500 | Oral Hygiene |
| 53181600 | Personal Hygiene Products Variety Packs |
| 53181700 | Baby Diapers/Accessories |
| 53201000 | Body Massage/Toning |
| 53220100 | Beauty/Personal Care/Hygiene Variety Packs |
| 58010100 | Cross Segment |
Other classifications can be found here: https://www.gs1.org/gpc/browser