May 19, 2014
Gcl wrote
we have feeds from different suppliers and as soon as the product is no longer available , most supplier simply remove those products from the CSV file so it is impossible for the system to know that item is out of stock unless we oversell it. and then we manually disable this product.
We were using magmi and custom module is available which will check entire csv file with the existing supplier inventory and delete the product which is not in the CSV
store manager has similar function but only thing is missing is a rule based product deletion , At the moment if i use this function of CSV matching then it will only keep one supplier products and delete all other products from our inventory
It will be a huge time saver if you can add a rule where it will only keep the CSV products and delete the products which matchs the rule
For example :
100 products in the inventory
10 products from Supplier A
50 products from Supplier B
40 Products from Supplier C
Now, If supplier B will send a new feed with only 49 products . In this case 1 product must be deleted from our databse as its no more available with a condition to check only for Supplier B
We can add one simple attribute in magento Like supplier feed Name : XYZ and it will cross check with this attribute every time we import and remove the products which matches this supplier name and do not touch other products
Thank you
We were using magmi and custom module is available which will check entire csv file with the existing supplier inventory and delete the product which is not in the CSV
store manager has similar function but only thing is missing is a rule based product deletion , At the moment if i use this function of CSV matching then it will only keep one supplier products and delete all other products from our inventory
It will be a huge time saver if you can add a rule where it will only keep the CSV products and delete the products which matchs the rule
For example :
100 products in the inventory
10 products from Supplier A
50 products from Supplier B
40 Products from Supplier C
Now, If supplier B will send a new feed with only 49 products . In this case 1 product must be deleted from our databse as its no more available with a condition to check only for Supplier B
We can add one simple attribute in magento Like supplier feed Name : XYZ and it will cross check with this attribute every time we import and remove the products which matches this supplier name and do not touch other products
Thank you
New
2 votes
Vote
Reply
12 Answers
May 20, 2014
Alex Pryshlivskiy
agent
wrote
thanks for comment.
According to part 1 : "we have feeds from different suppliers and as soon as the product is no longer available , most supplier simply remove those products from the CSV file so it is impossible for the system to know that item is out of stock unless we oversell it. and then we manually disable this product."
This task in our future To-Do list.
According to part 2: "We were using magmi and custom module is available which will check entire csv file with the existing supplier inventory and delete the product which is not in the CSV"
WE didn't quite understand how to operate with mentioned below example :-(
Could you share your magmi settings to reproduce this behavior?
According to part 1 : "we have feeds from different suppliers and as soon as the product is no longer available , most supplier simply remove those products from the CSV file so it is impossible for the system to know that item is out of stock unless we oversell it. and then we manually disable this product."
This task in our future To-Do list.
According to part 2: "We were using magmi and custom module is available which will check entire csv file with the existing supplier inventory and delete the product which is not in the CSV"
WE didn't quite understand how to operate with mentioned below example :-(
Could you share your magmi settings to reproduce this behavior?
May 20, 2014
Gcl
wrote
HI Sergiy
thanks for reply , does this mean that you are going to implement rule based CSV import in near future ? so it will only delete the respective supplier products Only.
Also for magmi , there is a plugin available called item disabler
Thanks
thanks for reply , does this mean that you are going to implement rule based CSV import in near future ? so it will only delete the respective supplier products Only.
Also for magmi , there is a plugin available called item disabler
Thanks
May 20, 2014
Alex Pryshlivskiy
agent
wrote
The implementation of this section: "we have feeds from different suppliers and as soon as the product is no longer available , most supplier simply remove those products from the CSV file so it is impossible for the system to know that item is out of stock unless we oversell it. and then we manually disable this product." in our future plans.
According to terms of implementation ? I guess it will be closer to the end of summer 2014.
According to second part of suggestion - we are not sure how to implement such behavior. Any ideas ?
According to terms of implementation ? I guess it will be closer to the end of summer 2014.
According to second part of suggestion - we are not sure how to implement such behavior. Any ideas ?
May 20, 2014
Gcl
wrote
Item disabler plugin is already available with default version ,however it will disable all products which is not present on the CSV so some one has added a condition to that plugin which works exactly the way i defined so it will check each product with that condition and if it does not match it will delete. i will get you a link as i type something like " magmi delete csv products" i wil get you a link
May 20, 2014
Alex Pryshlivskiy
agent
wrote
Video explanation of this suggestion will be great :-) You can use Jing for this.
Jun 18, 2014
Alex Pryshlivskiy
agent
wrote
By the way - New Feature - "Custom SQL" will be available in next Release of Store Manager for Magento PRO version only.
Standard Edition will work with this enhanced improvement.
The term of realization - in the middle of July. I guess.
Standard Edition will work with this enhanced improvement.
The term of realization - in the middle of July. I guess.
Jun 18, 2014
Makbul
wrote
HI
thanks for the update , does this mean that i can now now use rule based import ? or it will cross check import file everytime and only import the file in csv and cross check with the same supplier and remove any data that is not present in the csv ?
thanks
thanks for the update , does this mean that i can now now use rule based import ? or it will cross check import file everytime and only import the file in csv and cross check with the same supplier and remove any data that is not present in the csv ?
thanks
Jun 19, 2014
Alex Pryshlivskiy
agent
wrote
We'll implement 2 types:
Type 1 (in future)
Example - I want to remove products where qty< 10 for manufacturer = Kodak
1. Import of csv file
2. Run SQL query with mentioned below condition.
3. After execution of SQL you'll get what you want :-)
Type 2 (closer to end of June):
You can select products from Product Grid and Run saved SQL through drop-down menu - see screenshot -
Type 1 (in future)
Example - I want to remove products where qty< 10 for manufacturer = Kodak
1. Import of csv file
2. Run SQL query with mentioned below condition.
3. After execution of SQL you'll get what you want :-)
Type 2 (closer to end of June):
You can select products from Product Grid and Run saved SQL through drop-down menu - see screenshot -
Jun 19, 2014
Makbul
wrote
What if the new CSV does not contain that product ?
most supplier simply remove products from the CSV file as soon as it is out of stock , and it will remain on our system forever , and that is the main issue
how it will solve this issue ?
most supplier simply remove products from the CSV file as soon as it is out of stock , and it will remain on our system forever , and that is the main issue
how it will solve this issue ?
Jun 19, 2014
Alex Pryshlivskiy
agent
wrote
You will create own SQL to remove products after import.
For example - by Last updated field
Remove products from base where field Last updated < current date.
For example - by Last updated field
Remove products from base where field Last updated < current date.
Jun 30, 2014
Gcl
wrote
HI Sergiy
Please can you put some guide on this , as i need to check each supplier feed and remove if its not in the CSV ,
Pls provide any example
thanks
Please can you put some guide on this , as i need to check each supplier feed and remove if its not in the CSV ,
Pls provide any example
thanks
Jun 30, 2014
Alex Pryshlivskiy
agent
wrote
Here it is short manual for expressions - http://www.mag-manager.com/useful-articles/how-to/how-to-input-missing-data-and-modify-existing-on-the-fly-by-means-of-expressions-in-the-process-of-magento-import/
You can use it for import
OR
order special paid service here - http://www.mag-manager.com/import-as-a-service/
In this case please indicate in details what exactly to get after import for our support team and we'll try to help you.
You can use it for import
OR
order special paid service here - http://www.mag-manager.com/import-as-a-service/
In this case please indicate in details what exactly to get after import for our support team and we'll try to help you.