HostedShop Help | CMS & Shop
Printer-friendly
Sitemap5.5.1. Import of data
If you earlier on have exported your products or users you can read it into the web shop again (import) by clicking on "Import". Find the file you wish to import (CSV or XML) and click "Import". It is both possible to add and delete products through the import so it is a good idea to keep a backup of an export file, so you always can go back. The import is limited to 5.000 products and/or variants. If you wish to import more than this your import file should be broken up into several parts and then imported.
Product export/import format
To import your products/variants it is important that they are in the same format as the export file. The format is explained below:
Data name |
Data description |
| PRODUCT_ID | Internal id for the product. Leave blank to create a new product. |
| VARIANT_ID | Internal id for the variant. Leave '0' to create a new variant. Variants can only be created for existing products. |
| VARIANT_TYPES | The ids of the variant types, seperated by '|'. The order and number of types must match the variantdata which the types represent for the given variant. These are displayed in the TITLE field, seperated by '|'. |
| CATEGORY_ID | Id number for the product category. This can be a main category or a sub category. |
| SUB_CATEGORY_ID |
If a product should be registered in secondary categories, the categories’ id-numbers can be added here separated by ”|”. This can be both main and sub categorys. E.g. |20|15| |
| MANUFACTURER_ID | Id number for the producer / brand. |
| DISCOUNT_GROUP | Id number for the products B2B discount group. Empty if none. |
| STATUS | Status for the product, "1" for active and "0" for not active. |
| DISABLE_ON_EMPTY | Status for the product if sold out, "1" for active and "0" for not active. |
| TITLE | The title of the product in the main language. If the line represents a variant the names of the variants variant data will be listed, seperated by '|'. The variant data can be changed or created by changing one or more of these values. If a variant data is entered which does not allready exist for the variant type it is created automatically. |
| DESCRIPTION | The short description of the product in the main language (for product lists). |
| DESCRIPTION_LONG | The long description of the product in the main language (for product details). |
| STOCK | Amount in stock, e.g. "5" for 5 items. |
| NUMBER | Item number for the product. |
| PRODUCT_LINK | The link of the product, remember "http://" at the beginning. |
| WEIGHT | The weight of the product, e.g. "10" for 10 kg. |
| BUY_PRICE | The purchase price of the product for internal use. |
| PRICE | The sales price of the product (without discount). |
| LIST_PRICE | The list price of the product. |
| DISCOUNT | The discount of the product, "0" if no discount. |
| DELIVERY_ID | Id for delivery time, ”standard” is standard delivery time without stock status |
| FOCUS_FRONTPAGE | Status for the product focus on the frontpage, "1" for active and "0" for not active. |
| FOCUS_CART | Status for the product focus in the cart, "1" for active and "0" for not active. |
| SEO_TITLE | Search engine title (Meta title) in the main language. |
| SEO_DESCRIPTION | Search engine description (Meta description) in the main language. |
| SEO_KEYWORDS | Search engine keywords (Meta keywords) in the main language. |
| DATE_ADDED |
Date of creation. Should be entered as: yyyy-mm-dd hh:mm:ss |
| DATE_UPDATED |
Date of update. Should be entered as: yyyy-mm-dd hh:mm:ss |
| URL_PICTURE | Complete link to the first image. Cannot be changed. |
| PICTURES |
Product images separated by |. Will always link to /upload_dir/shop/. E.g. 44182.jpg|285912.jpg |
| URL | Complete link to the product. Cannot be changed. |
| DELETE | Enter "1" in this column if you wish to delete it. |
"TITLE" is required when adding new products through the import function.
If you are in doubt of the data’s function you can find help in the paragraph about Create product.
User export/import format
To import your users it is important that they are in the same format as the export file. The format is explained below:
Data name |
Data description |
| USER_ID | Internal id for the user - do not change this. |
| USER_TYPE | Usertype, "Privat" for private, "Erhverv" for company and "Offentlig" for public. |
| USERNAME | Username for the user (e-mail address). |
| PASSWORD | Password for the user. |
| USER_GROUP | Id number for the user category. Dette kan være et id for en hovedkategori eller underkategori. |
| ACTIVE | Status of the user, "yes" for active and "no" for not active. |
| DISCOUNT_GROUP | Discount group of the user. |
| FIRSTNAME | Firstname of the user. |
| LASTNAME | Lastname of the user. |
| GENDER | Sex of the user. |
| COMPANY_NAME | Company name of the user. |
| CVR | Company CVR number of the user. |
| EAN | Public EAN number of the user. |
| ADDRESS | Address of the user. |
| ZIPCODE | Zipcode of the user. |
| CITY | City by the user. |
| COUNTRY | Country code (ISO) of the user, ex. "DK". |
| COUNTRY_CODE | Country phone number (ISO) of the user, ex. "45". |
| PHONE | Phone number of the user. |
| MOBILE | Mobile phone number of the user. |
| FAX | Fax number of the user. |
| WEBSITE | Website of the user. |
| E-mail address of the user. | |
| DESCRIPTION | Description of the user. |
| NEWSLETTER | Newsletter subscription of the user, "yes" or "no". |
| REFERENCE | Reference of the user. |
| DATE_ADDED |
Date of creation. Should be entered as: yyyy-mm-dd hh:mm:ss |
| DATE_MODIFIED |
Date of update. Should be entered as: yyyy-mm-dd hh:mm:ss |
| DELETE | Enter "1" in this column if you wish to delete it. |