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.
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
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.
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
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.
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
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
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 ?
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
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
Alex Pryshlivskiy
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
Alex Pryshlivskiy
agent
wrote
ok, I see
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)
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
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
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.
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.
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
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.
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?
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
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.
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
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 ?
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)
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
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
Feb 25, 2014
Teodor
wrote
But this will deactivate all product from other vendors (brands that are not CASIO)?
Feb 26, 2014
Alex Pryshlivskiy
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
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
Alex Pryshlivskiy
agent
wrote
ok. please vote for this suggestion.
Right now I can see 1 vote only :-(
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
Alex Pryshlivskiy
agent
wrote
ok, Teodor
I see
Thanks for comment, let's wait for result.
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.
Maybe you can change it to : Import Products by Manufacturer or something similar.
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. :-(
unfortunately, I can't change the subject OR you can create new Feature Request with necessary subject. :-(
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
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?
can you tell more about this function?
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
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
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, 2018
Yura Senkiv
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.
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!
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!
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!
thx!
Jan 15, 2020
Yura Senkiv
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
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