Magento 2.4.3 p1, API and SQL coding
Budget: $250 – $750 USD
Description:
Please note. The developer I am looking for must know what he is doing. I just had a developer who has spent 2 days on a simple api that should take 4 hours.
And... Do not take me for a fool. I check the code. I ask you to make comments in the code when you work and also ask you to push code to git.
There will be NO access to the server.
If you ask for payment outside I will report you immediately.
Please give cost and timeline for EACH task.
Phase 1:
Bug 193, 161 (only finding path), 230, 229, 231, 245
Phase 2:
Bug 190, 188
Phase 3:
Bug 189
Work via git only.
Not on the sever
Priority:
1. 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"
2. 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
3. BUG 230
Stripe must have the customer code in the magento database so we can store and retrieve it so we can retrieve cards from stripe.
4. BUG
API should store and retrieve the country code when the user is adding its address to the customer information screen.
5. BUG 231
Missing VIP points when the product is clicked on in the store
It should be the SKU API, API 110
6. Bug 245
price is wrong in review filter and then it is listed
7. BUG 190 - This may be paused and waited for a few weeks.
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/"
8. BUG 188
Website performance "The site is slow Must be Ranking B or C
https://gtmetrix.com/
9. 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.
Please note. The developer I am looking for must know what he is doing. I just had a developer who has spent 2 days on a simple api that should take 4 hours.
And... Do not take me for a fool. I check the code. I ask you to make comments in the code when you work and also ask you to push code to git.
There will be NO access to the server.
If you ask for payment outside I will report you immediately.
Please give cost and timeline for EACH task.
Phase 1:
Bug 193, 161 (only finding path), 230, 229, 231, 245
Phase 2:
Bug 190, 188
Phase 3:
Bug 189
Work via git only.
Not on the sever
Priority:
1. 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"
2. 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
3. BUG 230
Stripe must have the customer code in the magento database so we can store and retrieve it so we can retrieve cards from stripe.
4. BUG
API should store and retrieve the country code when the user is adding its address to the customer information screen.
5. BUG 231
Missing VIP points when the product is clicked on in the store
It should be the SKU API, API 110
6. Bug 245
price is wrong in review filter and then it is listed
7. BUG 190 - This may be paused and waited for a few weeks.
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/"
8. BUG 188
Website performance "The site is slow Must be Ranking B or C
https://gtmetrix.com/
9. 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.