Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Magmi errors when creating new products
finity.trading

New
December 12, 2017 - 10:39 am
Member Since: December 1, 2017
Forum Posts: 3
sp_UserOfflineSmall Offline

Hi

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[22007]: 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[22007]: Invalid datetime format: 1366 Incorrect integer value: ‘None’ for column ‘value’ at row 3 – ERROR ON RECORD #1
error 3:SQLSTATE[23000]: 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[23000]: 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.

Thanks

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.

Avatar
Dave Furness

Founder
December 14, 2017 - 12:39 pm
Member Since: July 19, 2013
Forum Posts: 4596
sp_UserOfflineSmall Offline

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

finity.trading

New
December 14, 2017 - 3:24 pm
Member Since: December 1, 2017
Forum Posts: 3
sp_UserOfflineSmall Offline

Hi Dave

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.

Regards
Chris

Avatar
Dave Furness

Founder
December 19, 2017 - 2:23 pm
Member Since: July 19, 2013
Forum Posts: 4596
sp_UserOfflineSmall Offline

Every expert was once a beginner

finity.trading

New
December 19, 2017 - 2:40 pm
Member Since: December 1, 2017
Forum Posts: 3
sp_UserOfflineSmall Offline

Hi Dave

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.

Regards
Chris

Avatar
Dave Furness

Founder
January 2, 2018 - 12:22 pm
Member Since: July 19, 2013
Forum Posts: 4596
sp_UserOfflineSmall Offline

Hey Chris,

Yes that is exactly the workaround I was thinking of. It reminds me of an issue I saw a few years ago where a company had the same product in separate warehouses and they used the prefix method to get around this.

Dave

Every expert was once a beginner

 

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.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
28 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5212

Posts: 27455

Administrators: Matthew Ogborne: 4565, Dave Furness: 4596