Jump to content
  • 0
axel_afp

Import error Prestashop 1.4!!!

Question

I cant import products to my store ...

APC PDU Rack , Swit (ID 2) Cannot be saved
Data truncated for column 'condition' at row 1
APC Acu pent (ID 3) Cannot be saved
Data truncated for column 'condition' at row 1


id_tax_rules_group (ID ) Invalid tax rule group ID, you first need a group with this ID.
Rewrite link for Array (ID 2)
Rewrite link for Array (ID 3)


...some help? THX.

Share this post


Link to post
Share on other sites

40 answers to this question

Recommended Posts

  • 0

C'mon , how can i set "condition" row if this is not listed on import products fields? Or why is data truncated? If i import categories>subcategories is working fine but with products bleah...i cant import anything. I am still waiting for some help!

Share this post


Link to post
Share on other sites
  • 0

i dont understand why to do this "Product code I ; I product description I ; I Product Price"(cuz is not working). On ps 1.3 this is working just fine but on ps 1.4 .0 .17 is not and is reported as bug also, so is not just me with this issue.....

Share this post


Link to post
Share on other sites
  • 0

1076 errors

AUQ7.35.0014 Cannot be saved
Data truncated for column 'condition' at row 1
AUQ7.35.0016 Cannot be saved
Data truncated for column 'condition' at row 1
AUQ7.43.0018 Cannot be saved
Data truncated for column 'condition' at row 1
AUQ7.43.0020 Cannot be saved
Data truncated for column 'condition' at row 1
AUQ7.43.0022 Cannot be saved
Data truncated for column 'condition' at row 1
AUQ7.35.0003 Cannot be saved
... etc

There are 1076 warnings

id_tax_rules_group (ID 0) Invalid tax rule group ID, you first need a group with this ID.
Rewrite link for Array a fost rescris ca auq7350014
id_tax_rules_group (ID 0) Invalid tax rule group ID, you first need a group with this ID.
Rewrite link for Array a fost rescris ca auq7350016
id_tax_rules_group (ID 0) Invalid tax rule group ID, you first need a group with this ID.
Rewrite link for Array a fost rescris ca auq7430018
id_tax_rules_group (ID 0) Invalid tax rule group ID, you first need a group with this ID.
Rewrite link for Array a fost rescris ca auq7430020

...etc .....


anyway thx for your help and any other suggestion are more than welcome....

Share this post


Link to post
Share on other sites
  • 0

It seems it is a bug, I have the same problem on version 1.4.0.17 but on the beta version or 1.3 versions works fine.

Example for every import:
# id_tax_rules_group (ID 0) Invalid tax rule group ID, you first need a group with this ID.
# Rewrite link for Array (ID ID) was re-written as test

Share this post


Link to post
Share on other sites
  • 0

.... and now i get this with latest prestashop 1.4.1.0 svn

Notice: Undefined index: Line in X:\XXX\XXX\XXX\wwwroot\classes\Tools.php on line 1765

Warning: Function getIndexedCategories() is deprecated in X:\XXX\XXX\XXX\wwwroot\admin123\tabs\AdminImport.php on line
in X:\XXX\XXX\XXX\wwwroot\classes\Tools.php on line 1765

Notice: Undefined index: Line in X:\XXX\XXX\XXX\wwwroot\classes\Tools.php on line 1767

Warning: copy(2) [function.copy]: failed to open stream: No such file or directory in X:\XXX\XXX\XXX\wwwroot\admin123\tabs\AdminImport.php on line 442

Notice: Undefined index: Line in X:\XXX\XXX\XXX\wwwroot\classes\Tools.php on line 1765

Warning: Function getIndexedCategories() is deprecated in X:\XXX\XXX\XXX\wwwroot\admin123\tabs\AdminImport.php on line
in X:\XXX\XXX\XXX\wwwroot\classes\Tools.php on line 1765

Notice: Undefined index: Line inX:\XXX\XXX\XXX\wwwroot\classes\Tools.php on line 1767

Notice: Undefined index: Line in X:\XXX\XXX\XXX\wwwroot\classes\Tools.php on line 1765

Warning: Function getIndexedCategories() is deprecated in X:\XXX\XXX\XXX\wwwroot\admin123\tabs\AdminImport.php on line
in X:\XXX\XXX\XXX\wwwroot\classes\Tools.php on line 1765

Notice: Undefined index: Line in X:\XXX\XXX\XXX\wwwroot\classes\Tools.php on line 1767
X14 errors

   APC Acumulator pent (ID 3) Cannot be saved
   Data truncated for column 'condition' at row 1
   APC Acumulator pent (ID 4) Cannot be saved
   Data truncated for column 'condition' at row 1
   APC Extensie garant (ID 5) Cannot be saved
   Data truncated for column 'condition' at row 1
   Suport perete LCD/P (ID 8) Cannot be saved
   Data truncated for column 'condition' at row 1
   Suport perete Micro (ID 9) Cannot be saved
   Data truncated for column 'condition' at row 1
   Suport perete TV 17 (ID 10) Cannot be saved
   Data truncated for column 'condition' at row 1
   Suport perete TV 21 (ID 11) Cannot be saved
   Data truncated for column 'condition' at row 1

XThere are 8 warnings Hide warning

   Error copying image: 2
   Rewrite link for Array (ID 3) was re-written as apc-acumulator-pent
   Rewrite link for Array (ID 4) was re-written as apc-acumulator-pent
   Rewrite link for Array (ID 5) was re-written as apc-extensie-garant
   Rewrite link for Array (ID 8) was re-written as suport-perete-lcdp
   Rewrite link for Array (ID 9) was re-written as suport-perete-micro
   Rewrite link for Array (ID 10) was re-written as suport-perete-tv-17
   Rewrite link for Array (ID 11) was re-written as suport-perete-tv-21

Share this post


Link to post
Share on other sites
  • 0

There is no help on this forum...as u can see from 900 views only 1 (ONE) guy try to help me....no presta team, no one....!!! For this problem you have to go to your database "ps_product" and change "Condition" row in your database to something like that:

42225_KxNjF69iIOc3bNQb3YG7_t

Share this post


Link to post
Share on other sites
  • 0

I have the same problem and have already posted a new topic in the forum.
I tried many times to import my csv file with 459 products in PrestaShop™ 1.4.0.17 without success and I get 918 error messages.
I’ve already imported exactly the same csv file successfully in PrestaShop™ 1.4.0.9.
Is there any change or modification of csv Import in the PrestaShop™ 1.4.0.17 that I ignore?
Thank you for any help.

Share this post


Link to post
Share on other sites
  • 0
For this problem you have to go to your database "ps_product" and change "Condition" row in your database to something like that:
1

Thanks a lot, it's working.

+advice: import up to 100 products in one csv
i also have warnings, but products where imported.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×