OpenCart 3.0 - Product Description Upload, Ajax Filter Set up and Hardcoded code removal
Budget: $10 – $30 USD
I need experienced OpenCart Developer to do some tasks -
1. Product Description upload.
I have copy of database.sql (entire copy of the site) from June 19, 2022 and I need only product descriptions from that database uploaded to our site.
2. BaselAjaxFilter
BaselAjaxFilter - is part of the template and working for Categories but I need it to set the same for Manufacturer and Specials pages. (they are gone after upgrade to Opencart 3.0 and then never set them up).
Also since that BaselAjaxFilter works ok – sorts the pages but somehow it is pulling pages that should not be there in a first place and indexes them for some reason. There is no robots.txt to tell them to stop. So there is a filter – works well and stops the pages from indexing but then it does indexes
shoes.html?page=10
sandals.html?page=11
sneakers/limit-75.html?page=3
slippers.html?limit=100
slippers.html?limit=50
kopecki/sort-price-asc/limit-75.html?page=2
clearance/sort-price-desc.html?page=33
garvalin/sort-rating-desc/limit-9.html?page=5
or I am getting sometimes this error – since I believe that BaselAjaxFilter is somehow connected with my old filter that I had on earlier version of that template BrainyFilter it is disabled.
Fatal error: Uncaught Exception: Error: Deadlock found when trying to get lock; try restarting transaction<br />Error No: 1213<br />UPDATE oc_cart SET session_id = '16e1b49547149cfdbfde778018' WHERE api_id = '0'
3. MicroData -
I have 2 microdata for each product. (whichever one you suggest we keep so we have one and working).
One is from Basel Template (this one shows errors) –
One from Complete SEO and that one works well in detail. –
However, 1 product shows 2 microdata for one product. (one with error and one is correct) . I want to keep that one from template maybe since maybe that is easier.
Or whatever one you suggest we keep and it is working. The one from SEO we can turn it off. The one from template we cannot turn it off.
4. Small Template Changes to remove Hard Coded Code.
Small changes in Template so they act normal as default in Opencart. They were added not by us some developer and now we are confused by it, so we rather have it normal like in default. Remove hardcoded data from Home Page, Product Pages, Manufacturer and Product Manufacturer only.
1. HomePage - Title, H1, H2, H3 – hardcoded (before the update) and I want to remove that and use SEO Option for Title, H1, H2, H3 for home page since we can change it if needed.
2. Product Pages Meta Tag Title showing as H1 – it is hard coded. We want to remove that since it makes things confusing. It was hard coded not by us.
We have SEO template that works correctly but since it is hard coded does backwards.
Meta Tag Title - shows normal and pulls description from that line - we want that
H1 - shows normal and pulls description from that line - we want that
3. Manufacturer Pages - we have SEO for Manufacturer Pages that works – but Meta Tag Title, H1, H2, H3, Meta Tag Description, Meta Tags, - but currently it does not pull noting from what we write in SEO – it is being pulled from Manufacturer Product Description Actual Text. -
3. Product Manufacturer/Manufacturer – remove hard coded name brand - we want a name actual Product Brand showing when indexing in google - now it indexes as word – “brand” - but it should be - for example - "Falcotto" - as a brand. Just like it is in default Opencart - (it was hard coded also)
We have in Language Option – so it does indexes the brand but we want to remove that hard coded option.
English product/manufacturer text_brand
4. Blog Pages - Update Empty Alt Text – extension/blog/blog/captcha – shows as empty alt text –
1. Product Description upload.
I have copy of database.sql (entire copy of the site) from June 19, 2022 and I need only product descriptions from that database uploaded to our site.
2. BaselAjaxFilter
BaselAjaxFilter - is part of the template and working for Categories but I need it to set the same for Manufacturer and Specials pages. (they are gone after upgrade to Opencart 3.0 and then never set them up).
Also since that BaselAjaxFilter works ok – sorts the pages but somehow it is pulling pages that should not be there in a first place and indexes them for some reason. There is no robots.txt to tell them to stop. So there is a filter – works well and stops the pages from indexing but then it does indexes
shoes.html?page=10
sandals.html?page=11
sneakers/limit-75.html?page=3
slippers.html?limit=100
slippers.html?limit=50
kopecki/sort-price-asc/limit-75.html?page=2
clearance/sort-price-desc.html?page=33
garvalin/sort-rating-desc/limit-9.html?page=5
or I am getting sometimes this error – since I believe that BaselAjaxFilter is somehow connected with my old filter that I had on earlier version of that template BrainyFilter it is disabled.
Fatal error: Uncaught Exception: Error: Deadlock found when trying to get lock; try restarting transaction<br />Error No: 1213<br />UPDATE oc_cart SET session_id = '16e1b49547149cfdbfde778018' WHERE api_id = '0'
3. MicroData -
I have 2 microdata for each product. (whichever one you suggest we keep so we have one and working).
One is from Basel Template (this one shows errors) –
One from Complete SEO and that one works well in detail. –
However, 1 product shows 2 microdata for one product. (one with error and one is correct) . I want to keep that one from template maybe since maybe that is easier.
Or whatever one you suggest we keep and it is working. The one from SEO we can turn it off. The one from template we cannot turn it off.
4. Small Template Changes to remove Hard Coded Code.
Small changes in Template so they act normal as default in Opencart. They were added not by us some developer and now we are confused by it, so we rather have it normal like in default. Remove hardcoded data from Home Page, Product Pages, Manufacturer and Product Manufacturer only.
1. HomePage - Title, H1, H2, H3 – hardcoded (before the update) and I want to remove that and use SEO Option for Title, H1, H2, H3 for home page since we can change it if needed.
2. Product Pages Meta Tag Title showing as H1 – it is hard coded. We want to remove that since it makes things confusing. It was hard coded not by us.
We have SEO template that works correctly but since it is hard coded does backwards.
Meta Tag Title - shows normal and pulls description from that line - we want that
H1 - shows normal and pulls description from that line - we want that
3. Manufacturer Pages - we have SEO for Manufacturer Pages that works – but Meta Tag Title, H1, H2, H3, Meta Tag Description, Meta Tags, - but currently it does not pull noting from what we write in SEO – it is being pulled from Manufacturer Product Description Actual Text. -
3. Product Manufacturer/Manufacturer – remove hard coded name brand - we want a name actual Product Brand showing when indexing in google - now it indexes as word – “brand” - but it should be - for example - "Falcotto" - as a brand. Just like it is in default Opencart - (it was hard coded also)
We have in Language Option – so it does indexes the brand but we want to remove that hard coded option.
English product/manufacturer text_brand
4. Blog Pages - Update Empty Alt Text – extension/blog/blog/captcha – shows as empty alt text –