Update products with unique identifier different from sku

Question

I would like to update magento products with Magmi. The import csv file (with products to be updated) contains a column with unique id values but they are different from the sku values in database. Sku identifiers aren't available in this import csv file. The unique values in the import csv are a product attribute. So magmi should look up the sku value corresponding with each unique identifier in the import csv and then update the product with the sku that has been found. Is there a way to achieve this ?

Answer 1

Yes , using the SKU Finder plugin.

Answer 2

You can update the product quantities by selecting the ProductId (not the sku) in your database query. You should probably include an index on the ProductID, so you don't get a performance hit.

Your situation is normal -- you have a user known external "identifier" but keep your information by an internal prcess identifier. The options are to include:

1. Create a "productid" table, use this as an foreign key in your "sku based" table (and index)
2. Create a "productid" table with a mapping to your SKU table and use "join" when updating

You could experiment with both options, but your case appears simple enough to use option 1.