ExcelPort - Product / Category / Customers Excel Export / Import
|Extension Name||ExcelPort - Product / Category / Customers Excel Export / Import||Rating|
|Date Added||24 January 2013||Request Support|
|Date Modified||4 May 2015||Report extension|
|ExcelPort 2.1.4 (For OpenCart 2.0x Only)||126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11||[ Download ]|
|ExcelPort 1.8.4||18.104.22.168, 1.5.2, 22.214.171.124, 1.5.3, 126.96.36.199, 1.5.4, 188.8.131.52, 1.5.5, 184.108.40.206, 1.5.6, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199||[ Download ]|
✯ ExcelPort 2.0 for OpenCart 2.0 JUST RELEASED ✯
Only with ExcelPort 2.0, you can safely port your data from OpenCart 1.5.x to the new OpenCart 2.0!
Read the tutorial on How to migrate from OpenCart 188.8.131.52+ to OpenCart 2.x with ExcelPort?
What is ExcelPort
ExcelPort is a is a reliable tool to export all your product data into Excel file, edit it, and then import it again in OpenCart with the modified products.
✯ Chunk Export/Import guarantee to throw your memory problems away
✯ QuickExport Export/Import suitable for large product databases
✯ Export/Import to Excel the whole data for all your products, including Options, Attributes, Specials etc
✯ Export/Import Categories & Attributes
✯ Create unlimited Export Filters (useful for large product bases)
✯ Multi-lingual and Multi-store support
What you can export with ExcelPort
All native OpenCart Product Fields
Attributes and Attribute Groups
✯ NEW Orders
"Great extension! This is exactly what I was looking for. No memory issue anymore. Excellent support. " pstruh
"That looks great, love the way you organised everything in the excel file." Rene Djuricek
FAQ and Licensing
You can find more information about module Licensing, Compatibility with MijoShop/AceShop and FAQ in the Documentation Tab
What is inside the ZIP:
✯ Installation Instructions - From A to Z, on the necessary steps to install the module.
✯ Release Log - Here you will find information on all the changes and latest additions to the module.
✯ Upload - All the necessary files you need to upload. Please make sure you follow the Installation Instructions prior to copying the files.
Q: Which product fields are supported by ExcelPort?
A: Product Name, Meta Tag Description, Meta Tag Keywords, Descriptions, Product Tags, Model, SKU, UPC, EAN, JAN, ISBN, MPN, Location, Price, Tax Class, Quantity, Minimum Quantity, Subtract Stock, Out Of Stock Status, Requires Shipping, SEO Keyword, Images, Data Available, Dimensions (L x W x H), Length Class, Weight Class, Status, Sort Order, Manufacturer, Categories, Related Products, Filters, Stores, Downloads, Related Products, Attribute, Option, Discount, Special, Reward Points, Design
Q: Does ExcelPort support CSV files?
A: No. Currently ExcelPort works only with .xlsx file format.
Q: I have a budget server, will I face any memory problems upon import/export?
A: No memory issues at all. ExcelPort features an unique chunk export/import which will allow you to import/export virtually infinite products separated in different files. The module owner is able to choose the number of products exported and imported.
Q: What are the server requirements for ExcelPort?
A: Hosting requirements needed to run ExcelPort are pretty modest, as follows:
- php_zip enabled (most of the hosting providers do have it)
- PHP 5.1+
Q: What else can I import/export with ExcelPort?
A: You can import and export all product/category and attributes data.
Q: Can I import new products without having to touch the existing ones
A: Yes. All you need to do is fill in the required information and leave the product IDs empty.
Q: What is the difference between Full mode and Quick Mode?
A: Full Mode is the default mode for managing your product information. It allows you to make the full use of all OpenCart product information.In Quick Mode, all of your products are distributed into single lines for faster data manipulation. The fields that are contained in the Quick More correspond to the Static Data in Full Mode. Please note that the Dynamic Data fields are not included. Quick Mode is very useful when you wish to edit a lot of static information in one go (for example increase the prices, or paste product quantities from other tables)
Q: What is a Static and a Dynamic field?
A: The Static fields are those that can hold a single value. The Dynamic fields are those that can hold an indefinite number of values.
Q: I have a spreadsheets with my products that I have created. Can I import it with ExcelPort?
A: In order to use ExcelPort you will have to arrange and fill in product details according to the pre-defined product fields. If you enter your own categories, change the display order, chances are you will not be able to import your file. If you stick to the pre-defined format your import will work awesome.
Q: Is ExcelPort compatible with OpenOffice?
A: No. OpenOffice does not seem to like the .xlsx format which is the default format for ExcelPort. As an alternative we always recommend using LibreOffice, which is Open Source, hence free and works awesome with ExcelPort.
Q: Is ExcelPort compatible with Dependent Options extension?
A: No. Currently ExcelPort is compatible only with native OpenCart product fields. We offer adding custom fields to ExcelPort as part of our Premium Services and you can request a quote for this at sales[.at.]isenselabs.com
Q: Is it possible to import an Excel with data from another e-commerce in Opencart with this module?
A: No. ExcelPort does not support imports/exports from other e-commerce platforms.
Q: I have a question that is not listed in the FAQ
A: Our team will be more than happy to answer your question. You can get in touch with us on this link: Ask a question
This product is a Single-Domain license only! If you want to use it on more than one domain, you need to purchase additional licenses of the product. You can find more information on our Licensing Policy here
Notice to Joomla AceShop/MijoShop users:
Customers running on MijoShop and AceShop or other Joomla port, must purchase our Extended Support Package. This is necessary as these ports (AceShop and MijoShop) are not OpenCart and it takes our team extra efforts to support them and keep them version consistent. Please mind that the payment is a one time fee and is paid on top of the module price.
Premium OpenCart Services:
We have compiled a list of premium services are common often-requested solutions for problems we perform for our customers. You can view our Premium OpenCart Services by submitting a request on:here. Alternatively you can enquire about our Premium Services at sales[.at.]isenselabs.com
Tags excel, excel port, export, import, excelport, excel bulk export, excel import, excel export, product import, product export, product bulk export, customer export, customer import, customers export, export v1, customers import, customer group export, product update, bulk product update, complete product update, full product update, complete export, export v2, import v1, import v2, complete import, attribute import, attribute export, product attribute import, export orders, product attribute export, category import, export category, import category, export categories, import orders, option export, option import, options import, options export, discount import, discount export, export oc1.5, import oc1.5 xls import, xls export, export oc2, import oc1.5, xlsx import, xlsx export, isense, isenselabs