Magento 2.4.3 p1, PHP and SQL coding mix of smaller and bigger job.
Budget: $250 – $750 USD
Priority:
Points are in the attached image
- Point 1-3 are done, checking and giving us URL for point 1. Points 2,3 is checking code
- Point 4, 5, 6 is to do.
- Point 7 may not be needed now.
Description:
BUG 193
change api 118 "Separate the parts in the banners so the app can link to skus properly
API 118 reworked response which contains
- banner image url
- promotional text
- sku or campaign number
current response of API 118 is not like that can be used to create banners in the app, because the object ""banner_content"" contains html code which is impossible for us to extract banner url from that html code"
BUG 190
Languages on pages "Languages to be added:
German, Swedish, Danish, Norwegian, Finish, French,
1) Separate site settings setup for each language and configuration settings for each language.
2) Header and footer design update to same as like for english language to other languages.
3) Need to recreate product with same options for each language.
4) Need to recreate pages, widgets, blocks for each language and link them like in english language.
5) Need to add translation file for all languages and add all phrases used in the site.
6) Change in all places of phtml, php, and js files the translation process.
Link: https://www.sitepoint.com/magento-2-translation-how-internationalization-works/"
BUG 189
Optimising API speeds for colours "SPECIAL case for this is available under signed NDA.The work is expected tro be divided into SQL code (the feeders) and into MAgento with search as part one, if no product is available then execute SQL scripts)
1) Adding Feeding and Repeater scripts in SQL procedure so that it loops through each row in `defcolourfacearea' table and calculate central colour and find the matching products and make entry in new table. - 16 hours.
2) Create CRON to detect new product is added and execute SQL procedure. - 1 hours (it is one line of code execution only)
3) Updating API 65, 63c, 6365, 93, 91 to fetch from new table if data exists in that, else run procedures and then save them in new table. - 10 hours.
BUG 188
Website performance "The site is slow Must be Ranking B or C
https://gtmetrix.com/
BUG 186, SQL coding
API 65
duplicates are received from the SQL code.
that should be single
in API 65, you can see that there are a lot of duplicates in the SQL response.
I had asked the SQL developer to only show ONE product if they have EXACTLY the same distance as you can see above
BUG164
API 20 not returning same results
"https://<URL>/rest/V1/custom/products?searchCriteria[filter_groups][0][filters][0][field]=name&searchCriteria[filterGroups][0][filters][0][field]=visibility&searchCriteria[filterGroups][0][filters][0][value]=4&searchCriteria[filter_groups][0][filters][0][value]=Clinique&searchCriteria[filter_groups][0][filters][0][condition_type]=like
Basically we are using this link for searching items in the product screen. In this API, we are sending the searched word and founf results. But all the time we pass anything, it gives the same result"
BUG 161
Amasty module group notification to mobile
1) Adding country code group to `customer groups` dropdown & create a new field for country code input by extending amasty module to our custom module DONE
2) On executing that campaign, then getting a list of all users for that country group. DONE
3) Sending push notifications to mobile for all users in that group. DONE
4) sharing the URL and testing it. TODO
Points are in the attached image
- Point 1-3 are done, checking and giving us URL for point 1. Points 2,3 is checking code
- Point 4, 5, 6 is to do.
- Point 7 may not be needed now.
Description:
BUG 193
change api 118 "Separate the parts in the banners so the app can link to skus properly
API 118 reworked response which contains
- banner image url
- promotional text
- sku or campaign number
current response of API 118 is not like that can be used to create banners in the app, because the object ""banner_content"" contains html code which is impossible for us to extract banner url from that html code"
BUG 190
Languages on pages "Languages to be added:
German, Swedish, Danish, Norwegian, Finish, French,
1) Separate site settings setup for each language and configuration settings for each language.
2) Header and footer design update to same as like for english language to other languages.
3) Need to recreate product with same options for each language.
4) Need to recreate pages, widgets, blocks for each language and link them like in english language.
5) Need to add translation file for all languages and add all phrases used in the site.
6) Change in all places of phtml, php, and js files the translation process.
Link: https://www.sitepoint.com/magento-2-translation-how-internationalization-works/"
BUG 189
Optimising API speeds for colours "SPECIAL case for this is available under signed NDA.The work is expected tro be divided into SQL code (the feeders) and into MAgento with search as part one, if no product is available then execute SQL scripts)
1) Adding Feeding and Repeater scripts in SQL procedure so that it loops through each row in `defcolourfacearea' table and calculate central colour and find the matching products and make entry in new table. - 16 hours.
2) Create CRON to detect new product is added and execute SQL procedure. - 1 hours (it is one line of code execution only)
3) Updating API 65, 63c, 6365, 93, 91 to fetch from new table if data exists in that, else run procedures and then save them in new table. - 10 hours.
BUG 188
Website performance "The site is slow Must be Ranking B or C
https://gtmetrix.com/
BUG 186, SQL coding
API 65
duplicates are received from the SQL code.
that should be single
in API 65, you can see that there are a lot of duplicates in the SQL response.
I had asked the SQL developer to only show ONE product if they have EXACTLY the same distance as you can see above
BUG164
API 20 not returning same results
"https://<URL>/rest/V1/custom/products?searchCriteria[filter_groups][0][filters][0][field]=name&searchCriteria[filterGroups][0][filters][0][field]=visibility&searchCriteria[filterGroups][0][filters][0][value]=4&searchCriteria[filter_groups][0][filters][0][value]=Clinique&searchCriteria[filter_groups][0][filters][0][condition_type]=like
Basically we are using this link for searching items in the product screen. In this API, we are sending the searched word and founf results. But all the time we pass anything, it gives the same result"
BUG 161
Amasty module group notification to mobile
1) Adding country code group to `customer groups` dropdown & create a new field for country code input by extending amasty module to our custom module DONE
2) On executing that campaign, then getting a list of all users for that country group. DONE
3) Sending push notifications to mobile for all users in that group. DONE
4) sharing the URL and testing it. TODO