322: Using the Bulk Export/ Import Extension in OpenCart
Written by Tim SissonNow that you have installed the bulk import/ export tool for OpenCart, you can begin using it to add or modify products in your OpenCart store. The first step is to export your existing products so you know how the spreadsheets work. Then you can add products to the spreadsheet offline and upload the file once you have finished.
- Log into the OpenCart Dashboard
- Go to System > Export/ Import
- Click “Export” to download an Excel spreadsheet of your current products
- Open the spreadsheet with the appropriate software such as Open Office or Microsoft Excel
- Once you are done adding the products you want to add, in the correct format as your current products are laid out on the spreadsheet, save the file
- Now, go back to your OpenCart dashboard to: System Export/ Import
- Choose the file you just saved on your local computer by clicking the “Choose File” button next to “Import from spreadsheet file:”
- Once you save selected a file, click “Import”
Notice at the bottom of the spreadsheet, there is 7 separate sheets to work with (categories, products, options, attributes, specials, discounts, and rewards)
Once you have successfully imports your categories and products you will get a message on the top of your screen letting you know it has completed.
If you need further assistance please feel free to ask a question on our support center.
Like this Article?
Tweet
Category
OpenCart
is it import function working properly in in extenstion
Hello munafa1,
It sounds like you are having trouble using the import function. We are happy to assist you, but we need more information, such as the exact error you are receiving, what type of browser you are using, what version of OpenCart you are running.
Also, could you provide a the specific steps you are taking, so we can attempt to replicate the issue, such as where you are clicking?
If you have any further questions, feel free to post them below.
Thank you,
-John-Paul
It sounds like you are having trouble using the import function. We are happy to assist you, but we need more information, such as the exact error you are receiving, what type of browser you are using, what version of OpenCart you are running.
Also, could you provide a the specific steps you are taking, so we can attempt to replicate the issue, such as where you are clicking?
If you have any further questions, feel free to post them below.
Thank you,
-John-Paul
Hey Tim, great article. One question: When you add your new items, ones that aren't yet in the OpenCart database, do you also add the fields that opencart populates, like _id, time_created, etc?
Hello Naught,
Thanks for your question. Yes, when you import data into another database, it needs to match the fields, otherwise the import will fail because of the data mismatch. It's important to note that the field data should match. For example, in OpenCart, the product id is a NUMERICAL value. This means that you cannot use text in the ID.
I hope this clarifies the issue . Please let us know you require any further assistance.
Regards,
Arnel C.
Thanks for your question. Yes, when you import data into another database, it needs to match the fields, otherwise the import will fail because of the data mismatch. It's important to note that the field data should match. For example, in OpenCart, the product id is a NUMERICAL value. This means that you cannot use text in the ID.
I hope this clarifies the issue . Please let us know you require any further assistance.
Regards,
Arnel C.
Latest Questions
If you need some help, submit your question to our Community!
We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)
Recent Questions
Need more Help?
Search
Ask the Community!
Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.
Current Customers
| Chat: | Click to Chat Now | E-mail: | support@InMotionHosting.com |
|---|---|---|---|
| Call: | 888-321-HOST (4678) | Ticket: | Submit a Support Ticket |