Support and Information

PRODUCT URLs

Sometimes even though you have placed a product url in Magento Admin, it doesn't show on the frontend.  Instead you see a URL like this

https://example.com/catalog/product/view/id/5026

https://example.com/catalog/product/view/id/5025/category/185

To fix product url - perform the following steps

On the database you view specific entries for that url using the following sql statements:

SELECT * FROM `url_rewrite` WHERE `target_path` LIKE '%4729%'

SELECT * FROM `catalog_product_entity_varchar` WHERE `value` LIKE '%57642-beu%'

In Magento 2 Admin do the following

Open the product in admin and add 1 to url ( uncheck Create Permanent Redirect for old URL )

Save 

Open the product in admin again and remove the 1 you added to the url in previous step ( uncheck Create Permanent Redirect for old

Every business sells a product or a service.  To succeed, you need to have good product or service and skills and means to sell it.  A good ERP software can help you with the second part - selling the product or service.  

Advantages of using a cloud solution vs buying software or taking a free one.  

1. No large initial investment and flexible monthly payments based on needs.  Buying software can be costly.  Localizing and modifying according to someone's needs even more costly.  Maintenance, backups, hosting / infrastructure can add up to your costs.
2. Cloud solutions are following industries best practices.  Following the business model that is embedded in the software will most likely improve your efficiency.
3. Cloud solutions are scalable - as your business needs grow so can your software.  

Some of the important characteristics of a good ERP / CRM solution

1. Software that keeps information about all your products.  Names, descriptions, pictures, user manuals, pricing, margins, inventory, etc.  A business must have all the necessary information about products and services.  Products should be flexible - you should be able to add any additional information about your products - colors, sizes, weight, materials, etc.  Locations, warehouses, expiry date, lots, and much more.

Magento 2 contains many modules that will not be used and are making it bigger and slower.  Backups and restores are both bigger and slower.  

How to remove unused Magento 2 modules

1. Cron jobs.  Common problems and fixes
2. Magento commands that might save your day
3. Changing Magento modes
4. Server memory check
5. Firewall settings - usually connected to site not available

Benefits from using Elasticsearch include:

• Advanced and quick searches on Magento catalog
• Multi-language support
• Support for stop words and synonyms
• Indexing does not affect customers until reindex is complete 

Go to Stores -> Configuration -> Catalog -> Catalog -> Use Flat Catalog Category

Or

Go to Stores -> Configuration -> Catalog -> Catalog ->  Use Flat Catalog Products

It might be a good idea to decrease Magento size on disk and number of files before doing a backup.  This way your backups will be smaller and faster and the restore will take less time.

Using a command: ( from Magento 2 root directory )

 du -a . | sort -n -r | head -n 20

This post will show you how to delete unused product images.  When deleting a product in Magento, the corresponding product images are not deleted