Import Data (basic/advanced add product import)
The Import/Export system is an advanced ekmPowershop feature. It allows you to easily Export large amounts of data out of your shop such as products and orders. The Import allows you to edit all aspects of your products and categories by uploading a formatted Import file.
To access the Import/Export system please log into your ekmPowershop account and navigate to features section. Look down the list until you see the import / export feature. If you do not see the option, then you may need to install that feature. Click here to see how.
In this guide we have 2 parts. Part 1 is how to create a basic import file with only the basic attributes that ekmPowershop needs to import a file. Part 2 is an advanced guide to show you how to create a complete popluated file.
The import file can be used to add products / edit products or delete products from your online shop.
In the first part of this guide we will show you how to create a basic file to get products added to your shop.
The import file needs to have the following attributes to be sucussfully imported into your online store:
| Action | CategoryPath |
| ID | Name |
| Price |
On this guide we have the following
| Action | CategoryPath |
| ID | Name |
| Description | Price |
| Image1 |
The completed file will show as:
Click to enlarge.
Tip1: An easy way to get the format is create a product using the online interface. Once done export your product date and use the file as a template to add the rest.
Tip2: When you import a file ekmPowershop will automatically create a restore point before the file is imported so if anything goes wrong within the hour you can resore your shop to before the file was imported.
To see an import file in action please watch the following video:
Once your file has been completed click here to to walk through the importing walkthrough.
Advanced Guide
| Action | CategoryPath |
| ID | Name |
| Price |
On this guide we have the following
| Action | CategoryPath |
| ID | Name |
| Code | Description |
| Brand | Price |
| RRP | Image1 |
| Image2 | Image3 |
| Image4 | Image5 |
| MetaTitle | MetaDescription |
| MetaKeyworda | Stock |
| Weight | TaxApplicable |
| Condition | GTIN |
| MPN | AdditionalDelivery |
| SpecialOffer | OrderLocation |
| OrderNote | Hidden |
To see an advanced import file in action please watch the following video:
Once your file has been completed click here to to walk through the importing walkthrough.
To see how to export your product data please click here
Please click onto the guides below if you would like to do the following with an import file:
- Add products
- Edit products
- Products
- Add/Edit/Delete products with variants
- Add/Delete products with option


