PrestaShop Forum

The best place in the world to ask questions about PrestaShop and get advice from our passionate community!

PrestaShop Forum

Jump to content

 

Import error Prestashop 1.4!!!

40 replies to this topic
#1
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
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.

#2
escalion

    PrestaShop Newbie

  • Members
  • Pip
  • 13 posts
Can you paste the CSV you are importing?

And make sure you use the correct delimiters...


Passages Malibu Holistic
jillian michaels dvd

#3
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
this is sample csv i am tring to import....

Attached Files



#4
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
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!

#5
dash trims shop

    PrestaShop Newbie

  • Members
  • Pip
  • 10 posts
You must paste new COLON between each COLONS and just ad ;
Looks like thus

Product code I ; I product description I ; I Product Price

I have easy imported in 1min all 3000 my products

#6
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
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.....

#7
dash trims shop

    PrestaShop Newbie

  • Members
  • Pip
  • 10 posts
Please check my upload sample without images,
All imported in 5min
success
cheers

#8
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
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....

#9
dash trims shop

    PrestaShop Newbie

  • Members
  • Pip
  • 10 posts
Let me see screenshots , Just use prt Sc Kay and paste to Paint with ctrl+V,
save as JPG
Thanks
me working perfect
Imported here: http://bull-bar.com/...p?id_category=5

#10
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
first 1(a,b,c,d)with "," and second 2(a,b,c) with";" ....

Attached Files

  • Attached File  1a.JPG   73bytes   794 downloads
  • Attached File  1b.JPG   95bytes   778 downloads
  • Attached File  1c.JPG   99bytes   772 downloads
  • Attached File  1d.JPG   87bytes   725 downloads
  • Attached File  2a.JPG   107bytes   722 downloads
  • Attached File  2b.JPG   113bytes   736 downloads


#11
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
...and 2c

Attached Files

  • Attached File  2c.JPG   86bytes   719 downloads


#12
dash trims shop

    PrestaShop Newbie

  • Members
  • Pip
  • 10 posts
Active 0 or 1 - Remove This or place 1 or 1 colon !
Check also other colons before import
Here is main mistake

#13
dash trims shop

    PrestaShop Newbie

  • Members
  • Pip
  • 10 posts
Please check attached file, Correct Import sample
DrumBun-Cheers

Attached Files



#14
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
i did that from the first time....it wont works ...condition row error

#15
dash trims shop

    PrestaShop Newbie

  • Members
  • Pip
  • 10 posts
No, complain 2images and find your error - ACTIV (must be category choice)

#16
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
i did setup "active" colon with 1 or ignore field ... and is not working

Attached Files

  • Attached File  1a.jpg   142bytes   814 downloads


#17
leganzaro

    PrestaShop Newbie

  • Members
  • Pip
  • 1 posts
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

#18
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
any news about this problem? how can we import products ?

#19
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
hello? there is no one who can help me with my problem???

#20
axel_afp

    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 posts
??? still no one who can help me with this bug?