Our FAQ page might help.justifymylove wrote: ↑Thu Nov 21, 2019 4:21 pmI installed the extension and make everything that is described in readme file but i cant import or export products - it says access denied. Please help me. I already make changes in user-user groups and give permission. My version of opencart is 2.2.0.0
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
The option 'Choose color' is indicated several times!
In the Settings tab, activate the value:
Use option_id instead of option name in files 'ProductOptions' and 'ProductOptionValues'
I tried to use 'Use option_id instead of option name in files 'ProductOptions' and 'ProductOptionValues' but г have the same result!!
How i can fix it?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I was using this extension for quite a while and it worked perfectly. Now I face strange problem.
Code: Select all
Problem is "start ID must be higher than 0"
Also, strange thing is this:
Code: Select all
Note: You are using an old or unknown version of the Export/Import Tool, please upgrade to the new version 3.21!
Currently used category IDs are between 346 and 472. Currently used product IDs are between -1 and 16234.
There is no error in error log.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
for example :
catalog/a70.jpg and catalog/a71.jpg
One of them would be the main product image, the other one an additional product image. They are to be listed in the worksheets 'Products' (column image_name) and 'AdditionalImages' (column image).kurdogluugur wrote: ↑Thu Dec 12, 2019 3:18 pmhow can upload 2 different photos (picture) for 1 product. in excel file
for example :
catalog/a70.jpg and catalog/a71.jpg
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I downloaded the sample export file to see the columns and data format. I noticed the XLS file contains many spreadsheets. I was wondering, is it possible to have everything in one spreadsheet?
My issue is the "Product Attributes" is on a separate spreadsheet from the "Products".
I have over 7700 products and each one has a different "Product Attributes" value.
Below are the values for only 1 product.
product_id attribute_group attribute text(en-gb)
7164 Technical Specs Thread Size 14
7164 Technical Specs Thread Reach 17.5
7164 Technical Specs Hex Size 16
7164 Technical Specs Seat Type Tapered
7164 Technical Specs Resistor Type Resistor
7164 Technical Specs Projection Type Projected
7164 Technical Specs Heat Range 5
7164 Technical Specs Center Electrode Type & Material Fine Wire Iridium
7164 Technical Specs No. of Ground Electrodes 1 Ground Electrode
7164 Technical Specs Terminal Type Solid
7164 Technical Specs Pre-Set Gap 0.060"
7164 Technical Specs Thread Pitch (mm) 1.25
Unless there is something that I am missing and maybe there is a way to do this?
Thank you in advance
Frank
I can import all products as delete existing and add as new but how can I update only few products like Change qty/price on existing products?
Do I have to use same excel format?
For all of your Mobile phone needs.
https://mitrecyclers.com
Yes, use the same format, in incremental mode. If you only want to change the quantity or price, you may only need the 'Products' worksheet for that.mitrecyclers wrote: ↑Sun Dec 29, 2019 10:09 amHi,
I can import all products as delete existing and add as new but how can I update only few products like Change qty/price on existing products?
Do I have to use same excel format?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I am afraid this is not possible. You have to use the 'ProductAttributes' worksheet for the products' attributes.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
store-id:layout-name,store-id:layout-name,....
For example:
Code: Select all
0:MyLayout,1:AnotherLayout
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
EI 3.22
Calc - ODS file (Libre)
Odd issue - Updating entire database - delete all data before import. On import I have some rows where full data isn't being imported.
Example
Data for columns affected - Product Name, Description, Meta Tag Title, Meta Tag Title Description, and Meta Tag Keywords.
Data: Anti Hero Shaped Eagle Overspray Orange Crusher 9.1
So it is only populating the Anti Hero portion the rest seems to be truncated. All other columns are importing correctly.
It has nothing to do with # of characters as some of the affected are more.
On Re-Export - data is missing.
It seems to be a formatting issue as I manually retyped the data for one product and then it imported correctly.
I have looked over several of the affected products and none of them have any special characters or view-able formatting issues.
Doing it manually would take me ... FRAK!
I know this is more an CALC issue than EI issue but I am hoping someone else has had this issue as I attempted to search for "how to determine formatting differences between cells" which was useless.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
It was some formatting issue. I had hoped someone here had came across the same issue as I assume lots of people here use Open/Libre Office.
I was trying to figure out how to view and compare formatting between either rows or specific cells. Needless to say searching for the was futile.
I have since fixed the issue. I noticed Libre has a "Clear Direct Formatting" command (CNtRL + M) which I tested and it worked so I did all of the effected columns in my spreadsheet. It now works. Though still dont know what was causing the issue.
Thanks
I am using Preorder extension in my website. Any chances to gather the Pre-order date information to excel? I would like to do the opposite way: set the pre-order date in excel, upload the file with many products and it should update on that Pre-order extension also.
Some pictures how it look in admin panel and front end is here: https://imgur.com/a/vpgGfkP
If I set datE_available in excel, the product is hidden until that date. It should be the way how to change these settings in Pre-order extensions without manual input.
Send me a PM with more details. In particular, what are the exact names and types of your extra DB fields, in what DB tables, introduced by your preorder extension?doviis wrote: ↑Mon Mar 02, 2020 4:30 pmHello,
I am using Preorder extension in my website. Any chances to gather the Pre-order date information to excel? I would like to do the opposite way: set the pre-order date in excel, upload the file with many products and it should update on that Pre-order extension also.
Some pictures how it look in admin panel and front end is here: https://imgur.com/a/vpgGfkP
If I set datE_available in excel, the product is hidden until that date. It should be the way how to change these settings in Pre-order extensions without manual input.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Users browsing this forum: No registered users and 110 guests