Followup import question

[mtoon]

We have a "Global" product master that has all of our products in it (all invisible) and then a specific product master for all of our customers that has their model number and pricing.  In the customer specific import we only have a few fields (but SKU is one of them).  The idea was to have the import just update these particular fields, but it's not doing that.  Any ideas?

Thank you

[ryan]

You could merge the files before doing the import. That way you have full control over the merge.

[ming]

Have you considered using the API to load these few fields instead of the import facility?  If you did you could implement your own matching rules and have greater control over your updates.

[mtoon]

The merge would take too long.  It's not an exact line by line match and to lookup each line in excel before the import would be too clumsy.  The real question is... why is the import completing (without error), but not doing anything?  Is there some field in there that has to be there to complete?

Using the API is a good idea, but it would seem the import should be able to handle this...  It didn't seem like there were any specific fields required in the import except product_id or SKU....  is this incorrect?

Thank you

[ryan]

We have a "Global" product master that has all of our products in it (all invisible) and then a specific product master for all of our customers that has their model number and pricing.  In the customer specific import we only have a few fields (but SKU is one of them).  The idea was to have the import just update these particular fields, but it's not doing that.  Any ideas?

I don't understand what you are attempting to do. Does it follow the logic I posted earlier regarding the matching of the id, sku etc. ?

[mtoon]

Yes.
File #1 "GlobalProductMaster.txt" has all the products (and all the columns) possibly available with an invisible tag set to "true".  It contains a v_products_sku column.  This file imports fine, BUT an immediate subsequent import duplicates all rows (problem posted to another thread).

File #2 "CustomerProducts.txt" has just a few columns (the properties we're allowing customers to change)  SKU (SAME as the above file), Model and Price.  When this file is imported, the idea is to update just the model number and price of the already existing row (imported from the file above).  This import seems to ignore the file.  No errors are thrown and no rows are updated or even inserted (which they shouldn't be).

Does that help?

[ryan]

It looks like the problem is that it doesn't detect the SKUs as being the same. Therefore instead of doing an update it tries to do an insert which fails because there isn't enough compulsory data.

[mtoon]

Yes, my question is... what is the required "compulsory" data?  Can you supply that?  I thought it was only the SKU or product_id..

[pete]

If you try manually entering a product using the admin app, all of the compulsory fields are yellow. The save button doesn't become active until you have entered all of the compulsory data.