I am currently following the Magmi course and have downloaded the 7 real life example.csv.
When I attempt to import the products on it with Magmi I get these errors
error 1:SQLSTATE: Invalid datetime format: 1366 Incorrect integer value: ‘None’ for column ‘value’ at row 3 – INSERT INTO mg_catalog_product_entity_int
(`entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`)
VALUES (?,?,?,?,?),(?,?,?,?,?),(?,?,?,?,?) ON DUPLICATE KEY UPDATE `value`=VALUES(`value`)
error 2:SQLSTATE: Invalid datetime format: 1366 Incorrect integer value: ‘None’ for column ‘value’ at row 3 – ERROR ON RECORD #1
error 3:SQLSTATE: Integrity constraint violation: 1048 Column ‘entity_type_id’ cannot be null – INSERT INTO mg_catalog_category_entity (entity_type_id,attribute_set_id,parent_id,position,level,path,children_count) VALUES (?,?,?,?,?,?,?)
error 4:SQLSTATE: Integrity constraint violation: 1048 Column ‘entity_type_id’ cannot be null – ERROR ON RECORD #2
warning:Skus imported KO:2/2
Any help on how to resolve these errors would be greatly appreciated.
Update: I think the issue is fix. I was using “None” as the cell input for “tax_class_id. Using a 0 instead stops these errors and selects None when the product is created in Magento.
Glad you managed to get it resolved. Magmi is a stickler for the rules ha ha it doesn’t interpret well
Every expert was once a beginner
Thanks for the reply. Your not wrong. Precision is certainly key with Magmi from what I have learnt so far.
I am loving the guides you and Matt have set up here. Thank you so much for them.
We have been using WidgetChimp for some time now but have shied away from tackling the step up from using Turbolister as Magento+M2E Pro seemed like such a mammoth and complex task. Its not so scary with your easy to follow guides (though still complex with alot to learn).
Not sure if this is the right area to ask (please let me know if I need to post under a different sub) but I am having some trouble figuring out how to properly use the combination of websites and store views to achieve what I want magento + m2e pro to do for me.
My situation is
I need multiple websites. Each with their own domain, eBay store and Amazon store. They will be selling the exact same products (same SKU’s) but at varying quantities and potentially prices too.
eg. I have product A that needs to have 3 units available on website 1 (along with its eBay store and Amazon store) and 10 units available on website 2 (with 10 units available on its own eBay and Amazon stores).
Currently I have been and created the different websites and created separate root categories for each website in Magento.
I can import product A into Magento and assign it to the correct categories in Website 1 with its desired quantity (in this example 3 units for website 1).
This issue arises when I then attempt to import the same product but with a different quantity and assign it to the correct category in Website 2.
The product is then removed from the categories in website 1 and moved to website 2.
Is there a way to stop the product moving or will I just have to use multiple SKU’s for the same product in order to achieve this?
Apologies for the length of this rant.
Give this thread a read here and check out the links this should help you out: https://understandinge.com/forum/multiple-store-questions/creating-multi-websites-and-stores-in-magento-separating-ebay-amazon-etc-sales-channels/
Every expert was once a beginner
Thanks again for the reply.
I have managed get get multiple websites up and running in the last few days which is great.
I believe I have also figured out that what I was asking for in regards to the SKU’s and how they might be handled can’t be done.
As the SKU is a unique identifier for a product any time I attempt to import that SKU into a different category using Magmi the previous category placement (and anything else I change) of that SKU will be updated.
The only solution I can think of is to use different variations of the SKU to assign it to each of my websites/stores. Simply using a prefix for each website should do the job, eg. Store A – IAMASKU and Store B – IAMASKU.
Both will be exactly the same product but they can now be assigned to different websites with their own category structure, quantaties, prices and all the rest.
Why Should You Join UnderstandingE?
- Access to over 500 step-by-step video tutorials
- +20 video courses available
- Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
- Everything is in 100% Plain English
- Learn how to build your own multi-channel software for eBay & Amazon
- Access to the community forums, meet fellow business owners like yourself
Join Now with 2 Clicks
Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.
Most Users Ever Online: 1012
Currently Browsing this Page:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Paul Cartwright: 414
Administrators: Matthew Ogborne: 4565, Dave Furness: 4519, Rodney - UE: 433