Post by Affableaardvark » Mon Oct 17, 2022 4:45 pm

Hello,
I am using Opencart 4.0.1.1 and php 8
When trying to import categories, I get the success banner, but there are no categories present.
Image
Please, do you have some ideas that I can try to fix it ?
Here is a link to the import sheet. https://205008.com/op4-cats.xlsx
Best wishes,
Bob

User avatar

Posts

Joined
Thu Apr 01, 2010 11:19 pm

Post by JNeuhoff » Mon Oct 17, 2022 6:40 pm

@Affableaardvark : If you send me a PM with your FTP and OpenCart admin details then I can take a look at it. I can't see anything wrong with your spreadsheet file.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Affableaardvark » Mon Oct 17, 2022 7:59 pm

Thank you for your quick reply.
It is no longer a problem :)
Best wishes,
Bob

User avatar

Posts

Joined
Thu Apr 01, 2010 11:19 pm

Post by tomeda » Thu Nov 10, 2022 8:57 pm

Hi,
I get this error trying to import customers:

Code: Select all

Export/Import: Worksheet 'Customers' can only be imported in incremental mode for the time being!
Export/Import: Worksheet 'Addresses' can only be imported in incremental mode for the time being!
Tried with truncate the table in PHPMyAdmin without any success.

I don't have any data in that table, so what could be the problem, any idea?!

OpenCart SEO Services
http://tomeda.bg


User avatar
New member

Posts

Joined
Thu Mar 19, 2015 4:48 am


Post by JNeuhoff » Thu Nov 10, 2022 10:49 pm

tomeda wrote:
Thu Nov 10, 2022 8:57 pm
Hi,
I get this error trying to import customers:

Code: Select all

Export/Import: Worksheet 'Customers' can only be imported in incremental mode for the time being!
Export/Import: Worksheet 'Addresses' can only be imported in incremental mode for the time being!
Tried with truncate the table in PHPMyAdmin without any success.

I don't have any data in that table, so what could be the problem, any idea?!
Use this setting in the Export/Import tool for the Import:

Use incremental Import:
Yes (Update and/or add data)

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by vrista » Mon Nov 14, 2022 5:40 pm

Hi, I have some questions.

1.) Does this extension support the import&export, newly add or update of product data fields which from other opencart marketplace extension ?? such as "related option"
Export/Import Tool ---- https://www.opencart.com/index.php?rout ... sion_id=17
Related Option ---- https://www.opencart.com/index.php?rout ... n_id=20902

2. ) My opencart version is 2.3.0.2., in Journal Theme 2.
Does this extension "Export/Import Tool" support and work this version and Journal Theme 2 ?? without error or database malfunction ??

Thank you.
Last edited by vrista on Mon Nov 14, 2022 5:44 pm, edited 1 time in total.

Newbie

Posts

Joined
Sat Feb 23, 2019 10:41 pm

Post by JNeuhoff » Mon Nov 14, 2022 8:02 pm

Extra DB fields introduced by 3rd party extensions aren't included by the Export/Import tool. For this, we can offer modifications for a small charge.

We don't support (nor recommend) the Journal framework because of its poor quality and because of not adhering to OpenCart standards. However, as far as I know the Journal framework doesn't introduce extra DB fields for the relevant category or products data, hence the Export/Import tool should be fine with this.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by FCWC » Sat Nov 19, 2022 6:07 am

OC Version 3.0.3.1
Export/Import Tool (V3.22)

Example data:
888560264526 Deck Width 8.25 -
The Filter Group and Filter are Text.
Side Note:Notice the - after 8.25 - . Thats there because it wouldn't ever work with just 8.25. is there a set of rules for structure somehwere?

New member

Posts

Joined
Tue Jul 31, 2012 3:17 am

Post by dippetas » Tue Nov 22, 2022 3:02 am

Hello,
i am facing a problem and i would like your assistance. I am using Opencart 3.0.2.0 with PHP 7.3.33 and Import export tool 3.22.
i am uploading an excell file with 103 new products and the products don't show up. Although the message that appears is success.

Newbie

Posts

Joined
Thu Aug 23, 2018 10:20 pm

Post by FCWC » Tue Nov 22, 2022 7:26 am

Check to make sure you have products Enabled.
Status column = true.
Less defaults to false.

Also note if formatting is concert, say under Description column. It will not put anything there and assume that it is right.

New member

Posts

Joined
Tue Jul 31, 2012 3:17 am

Post by dippetas » Thu Nov 24, 2022 2:02 am

thank you for your reply.
i found the solution to my problem, the problem was the language that was assigned to the products.

Newbie

Posts

Joined
Thu Aug 23, 2018 10:20 pm
Who is online

Users browsing this forum: No registered users and 2 guests