Magento 2 - data cleaner remove unused data automatically - running as affiliate store
Budget: $10 – $30 USD
Hi,
If you are not an experienced “Magento specialist” please don’t apply for this job.
I’m running on Magento ver. 2.3.4 with Cpanel.
The Magento store “only works as affiliate store” it is not possible to order or buy any products from my website. All the products you will see on the store are affiliate products, when you click on the products you will be redirected to another store which the purchase can be made from.
I have some customizations on current theme and modules, the theme is: Ultimo Fluid Responsive Magento Theme by infortis, you must ensure not to lose any settings.
Currently there are around 41000 products, but I plan to import many more.
Import is done via Firebear import extension.
I Import products from many different online stores via product feeds, XML or CSV files.
A cron job is triggered every day to run the import process with flush cache/reindex so everything automatically is updated from the different products feeds I make import from.
The import extension automatically detects and deletes products which no longer are in the product feeds I get data from, this means products are deleted from my store catalog.
The issue is, I noticed after a while with same number of products that my websites space is increasing much, same goes for the DB - therefor performance also goes down over time.
Task.
1. I would like some kind of automatically clean-up process to run 1 time each day so that a total clean up can be made from unused data, running via script or cron, or whatever is possible. I have checked on the web, and can see that there are multiple solutions, but I don’t know what is best.
Old data after product has been deleted from the catalog is still stored in DB (orphaned records) and file folders, media files. DB contains as old data in tables such as from images, products and attributes, value data
2. My file usage is over 1.4 million files which seems high, total clean up needed.
3. To make performance better I would like you to remove \ disable unnecessary running Magento processes which “I don’t need for running as actual shop\store” since it’s running as an affiliate shop and none purchase can be made, buy and order not needed.
I already disabled some modules, and there are probably more. Example in the cron log I can see “sales_grid_order” is running, example of what I don’t need – that’s why I need some professional Magento specialist eyes on this, so it can be improved.
I have both a staging and live site and would like to keep the same settings on both, so that they are identical.
PLEASE READ BELOW: * I ONLY hire people with +6 years Magento experience * I would like communication on Skype if possible, payments will only be made over Freelancer.com and no other services * You must have experience with the same job type from previous work * Copy paste messages will be ignored
If you are not an experienced “Magento specialist” please don’t apply for this job.
I’m running on Magento ver. 2.3.4 with Cpanel.
The Magento store “only works as affiliate store” it is not possible to order or buy any products from my website. All the products you will see on the store are affiliate products, when you click on the products you will be redirected to another store which the purchase can be made from.
I have some customizations on current theme and modules, the theme is: Ultimo Fluid Responsive Magento Theme by infortis, you must ensure not to lose any settings.
Currently there are around 41000 products, but I plan to import many more.
Import is done via Firebear import extension.
I Import products from many different online stores via product feeds, XML or CSV files.
A cron job is triggered every day to run the import process with flush cache/reindex so everything automatically is updated from the different products feeds I make import from.
The import extension automatically detects and deletes products which no longer are in the product feeds I get data from, this means products are deleted from my store catalog.
The issue is, I noticed after a while with same number of products that my websites space is increasing much, same goes for the DB - therefor performance also goes down over time.
Task.
1. I would like some kind of automatically clean-up process to run 1 time each day so that a total clean up can be made from unused data, running via script or cron, or whatever is possible. I have checked on the web, and can see that there are multiple solutions, but I don’t know what is best.
Old data after product has been deleted from the catalog is still stored in DB (orphaned records) and file folders, media files. DB contains as old data in tables such as from images, products and attributes, value data
2. My file usage is over 1.4 million files which seems high, total clean up needed.
3. To make performance better I would like you to remove \ disable unnecessary running Magento processes which “I don’t need for running as actual shop\store” since it’s running as an affiliate shop and none purchase can be made, buy and order not needed.
I already disabled some modules, and there are probably more. Example in the cron log I can see “sales_grid_order” is running, example of what I don’t need – that’s why I need some professional Magento specialist eyes on this, so it can be improved.
I have both a staging and live site and would like to keep the same settings on both, so that they are identical.
PLEASE READ BELOW: * I ONLY hire people with +6 years Magento experience * I would like communication on Skype if possible, payments will only be made over Freelancer.com and no other services * You must have experience with the same job type from previous work * Copy paste messages will be ignored