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.
Completed
5 votes
Vote
Reply
36 Answers
Avatar image
Apr 25, 2013
Alex Pryshlivskiy agent wrote
Hello !
Thanks for request.
According to our Policy, we implement a new features according to the volume of cutomer votes.
Avatar image
Feb 17, 2014
Teodor wrote
I am vote for this
Avatar image
Feb 18, 2014
Alex Pryshlivskiy 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.
Avatar image
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
Avatar image
Feb 18, 2014
Alex Pryshlivskiy 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 ?
Avatar image
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
Avatar image
Feb 18, 2014
Alex Pryshlivskiy agent wrote
ok. thanks for comment. It's enough for me.
Avatar image
Feb 18, 2014
Teodor wrote
I need the same functions and for CreLoaded Store Manager (also and for Magneto)
Avatar image
Feb 18, 2014
Alex Pryshlivskiy agent wrote
ok, I see
Avatar image
Feb 20, 2014
Alex Pryshlivskiy 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)
Avatar image
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
Avatar image
Feb 23, 2014
Alex Pryshlivskiy 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.
Avatar image
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.
Avatar image
Feb 24, 2014
Alex Pryshlivskiy 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.
Avatar image
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?
Avatar image
Feb 25, 2014
Alex Pryshlivskiy 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.
Avatar image
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?
Avatar image
Feb 25, 2014
Alex Pryshlivskiy 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 ?
Avatar image
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)
Avatar image
Feb 25, 2014
Alex Pryshlivskiy 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
Avatar image
Feb 25, 2014
Teodor wrote
But this will deactivate all product from other vendors (brands that are not CASIO)?
Avatar image
Feb 26, 2014
Alex Pryshlivskiy agent wrote
ok. let's wait for customer votes and comments
Avatar image
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

Avatar image
Feb 26, 2014
Alex Pryshlivskiy agent wrote
ok. please vote for this suggestion.
Right now I can see 1 vote only :-(
Avatar image
Feb 26, 2014
Teodor wrote
You can ask any store owner who works with few products feed that this is must have function.
Avatar image
Feb 26, 2014
Alex Pryshlivskiy agent wrote
ok, Teodor
I see
Thanks for comment, let's wait for result.
Avatar image
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.
Avatar image
Feb 27, 2014
Alex Pryshlivskiy agent wrote
Hello Teodor,
unfortunately, I can't change the subject OR you can create new Feature Request with necessary subject. :-(
Avatar image
Feb 05, 2016
Ira Kobylianska 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
Avatar image
Feb 05, 2016
Teodor wrote
Hello Ira,
can you tell more about this function?
Avatar image
Feb 08, 2016
Ira Kobylianska 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, 2018
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
Avatar image
Oct 29, 2018
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.
Avatar image
Jan 15, 2020
Hein wrote
Hello Team,

We also experience difficulties with Automatic Import. It will create a backup first and will go through ALL items to identify which items need an update. Our backup takes about 3 hours to run.... :(

Second, Many stock files come from different manufacturers so it is not neccessary to scan through the complete database, only through the items associated with this manufacturer.

Suggestion / question: Make a 'selection range' possible by import Configuration to be able to update much quicker. (ie. update only selected range)

Also: is it possible to skip the backup (maybe if backup is not older than 24 hours??) ie: if we backup over night, we can run automated import without making extra backup..

Both suggestions added in the screenshot.

Have a good one!

Hein

Thanks for your kind thoughts!

Avatar image
Jan 15, 2020
Hein wrote
Team, appologies, you have added a custom SQL button so I would be able to only make adjustments on predefined products.. (question: how can I make sql query stating: only update products with sku starting with '256'

thx!
Avatar image
Jan 15, 2020
Yana Kostyk agent wrote
Please contact us via email (contact@mag-manager.com) with the following files so our techs could help you with the sql expression for your import:

1) Store Configuration file (can be saved in Preferences(F12) > Save current configuration https://www.screencast.com/t/eKt3AlWk0l5M )
2) Import file
3) Import configuration file (can be saved on the last step of the import: in cfg format https://www.screencast.com/t/Gb5Sm0D7Kr8g )

* do not post any data here since this is a public forum