Automated Product Import,

Automated Product Import,

Avatar image
Apr 25, 2013
Mark Nichols wrote
HI, would be really useful to be able to apply an import for a specific manufacturer, and then use the rules of, mark as disabled if not in import, to that one manufacturer only.

At the moment the rules work only on a global basis?

We have multiple manufacturers each supplying a feed with pricing and stock level to import, and would like to disable magento items automatically when the item drops of the manufacturers feed.
3votes
Completed
Vote
Reply
33 Answers
Apr 25, 2013
Sergiy Kibitkin agent wrote
Hello !
Thanks for request.
According to our Policy, we implement a new features according to the volume of cutomer votes.
Feb 17, 2014
Teodor wrote
I am vote for this
Feb 18, 2014
Sergiy Kibitkin agent wrote
Do you want to create special filter by manufacturer for Product Import.
Am I right? Acc. to filter logic - don't import product with selected manufacturer.
Feb 18, 2014
Mark Nichols wrote
Hi, I wold like to be able to select which manufacturer the import refers to, so that we can use the "disable if not in feed" feature.

At the moment we are unable to use this as we have multiple manufacturers and a different feed from each.

So if enabled currently, we import one feed and all other manufacturers items are disabled.

So we want to select manufacturer, import feed to effect that manufacturers products only.

Thanks

Mark
Feb 18, 2014
Sergiy Kibitkin agent wrote
Thanks for suggestion.
I'll try to discuss this idea with our development team.
I need from you detailed example of logic for this suggestion.
Could you provide it plesase ?
Feb 18, 2014
Teodor wrote
Hi,
I need the same function.
If I import products from vendor and they send me file for products with brand/manufacturer XXXXX and some product with brand/manufacturer XXXXX is not included in this feed, the status of the product to be changed to 0 (inactive, out of stock and etc.).
You have to add new options do identify a product, not only ID, name+model or name of the product but manufacture+model, manufacturer+name

Thank you
Feb 18, 2014
Sergiy Kibitkin agent wrote
ok. thanks for comment. It's enough for me.
Feb 18, 2014
Teodor wrote
I need the same functions and for CreLoaded Store Manager (also and for Magneto)
Feb 18, 2014
Sergiy Kibitkin agent wrote
ok, I see
Feb 20, 2014
Sergiy Kibitkin agent wrote
By the way, you can use expression for Cotrol of Manufacturer name and SKU.

if([CSV_COL(28)]='Canon',[CSV_COL(53)],'')

in this expression you can control field 29 ( in this example it's Manufacturer field)
field 53 - SKU field.

If we have product with manufacturer = Canon then don't touch SKU ELSE remove SKU fduring of the import.
Taking into account that fact, you can't import products without SKU (identification method was selected by you before import).
Products without SKU will not be imported by program (SKU method was selected)
Feb 21, 2014
Teodor wrote
Hi,
the function is not the same.
I am asking how to deactivate product in the shop which are not in the import file for some manufacturer.

Teodor
Feb 23, 2014
Sergiy Kibitkin agent wrote
Hmm... you've asked about import: "HI, would be really useful to be able to apply an import for a specific manufacturer, and then use the rules of, mark as disabled if not in import, to that one manufacturer only.

At the moment the rules work only on a global basis?"

According to your question you've entered the following title for Feature Suggestion: "Automated Product Import,"

If you want to change availability of product according to Manufacturer in bulk, you should open another Feature request for this operation.
Feb 24, 2014
Teodor wrote
Yes, maybe I not describe correct the problem but this is for import.
If I have a product with manufacturer - XXXXXXX with SKU 1111111 and I am importing new file for this manufacturer but the product with SKU 1111111 is not in this file, I need to deactivate (status 0, out of stock or etc) for this product because this product is not offered anymore.
Feb 24, 2014
Sergiy Kibitkin agent wrote
Teodor,
why don't you want to use expressions in this case? - see my comment above.
if([CSV_COL(28)]='XXXXXX',[CSV_COL(53)],'')
This option is ready to use in STore Manager.
Feb 24, 2014
Teodor wrote
Hi,
but this option is to skip from import a new product not to deactivate a product which already is in my store.
Am I correct?
Feb 25, 2014
Sergiy Kibitkin agent wrote
ok, in this case you can use Manufacturer field and Status (1 - product is enabled, 0 - is not enabled)
if([CSV_COL(28)]="Canon",0,1)
where col #28 is Manufacturer column for imported file.
Feb 25, 2014
Teodor wrote
Will this put a status 0 for a product which is in the store but is not in the product feed?
Feb 25, 2014
Sergiy Kibitkin agent wrote
ok, Teodor.
I didn't quite catch.
Do you want to "hide" products from store according to Manufacturer name?
OR
Do you want to "hide" products from store after import of products ?
Feb 25, 2014
Teodor wrote
I want to hide product from store which is not in new product feed.
If I import a feed with products:

CASIO, 101010, $219
CASIO, 101011, $240
CASIO, 101012, $178

and next time I receive a new file:

CASIO, 101011, $220
CASIO, 101012, $175

I want the product: CASIO, 101010, $219 which is in my store but is not in new product feed to receive status 0 (out of stock)
Feb 25, 2014
Sergiy Kibitkin agent wrote
ok, in this case you can use this option - see screenshot - https://www.dropbox.com/s/iby98tvi1gza5zx/2014-02-25%2018_10_40.png
Feb 25, 2014
Teodor wrote
But this will deactivate all product from other vendors (brands that are not CASIO)?
Feb 26, 2014
Sergiy Kibitkin agent wrote
ok. let's wait for customer votes and comments
Feb 26, 2014
Mark Nichols wrote
HI,

What Teodor has said is exactly what I was trying to convey at the beginning.

We have more than one import feed and as such the Deactivate if not in feed option cannot be used.

We just need a way at the beginning of the import process to specify to only work with products from a specific manufacturer

Feb 26, 2014
Sergiy Kibitkin agent wrote
ok. please vote for this suggestion.
Right now I can see 1 vote only :-(
Feb 26, 2014
Teodor wrote
You can ask any store owner who works with few products feed that this is must have function.
Feb 26, 2014
Sergiy Kibitkin agent wrote
ok, Teodor
I see
Thanks for comment, let's wait for result.
Feb 26, 2014
Teodor wrote
Maybe you can change the subject. Because the problem is not only for automated import this function is important and for manual import.
Maybe you can change it to : Import Products by Manufacturer or something similar.
Feb 27, 2014
Sergiy Kibitkin agent wrote
Hello Teodor,
unfortunately, I can't change the subject OR you can create new Feature Request with necessary subject. :-(
Feb 05, 2016
Maksym Dranivskyi agent wrote
Hello!

Newest Store Manager versions allow to set SQL during import and Update products by Manufacturer. You are welcome to update to get newest functionality

Feel free to contacrt us if you have any questions
Feb 05, 2016
Teodor wrote
Hello Ira,
can you tell more about this function?
Feb 08, 2016
Maksym Dranivskyi agent wrote
Hello Teodor!

Thank you for your question

You can check the feature overview at the following article:
http://store-manager-for-magento-documentation.emagicone.com/advanced-management/custom-sql/custom-sql-linked-to-products-import

Please note, that feature is available in latest versions only. If you want any specific SQL statement to be created, please submit a ticket with requirements and we will provide with estimated cost:
https://support.emagicone.com/submit_ticket

Let us know if you have more questions
Oct 29 (42 days ago)
Anonymous wrote
Hello Team,

I have a similar problem and i hope you can help me. I create a new attribute called vendor and we associate all products by vendor and i want to change product visibility to "Not Visible Individualy" and stock status to "Out of Stock" for products that are not in the feed depending on vendor. Is there any way to do this?

Regards,
Alin
Oct 29 (42 days ago)
Yana Kostyk agent wrote
Please contact us at contact@mag-manager.com with your import file and with more detail so we could try to assist you and find the best possible solution in your case.