[Nishit Shan]

in reply to: Maseter Port Out PIN #13819

Hello Andrey,

Sorry , But may be i am not getting your exact point about order problem, because updateinventory API is for ordering which is working. Can you please specify the specific point where they are getting problem.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13817

Hello Andrey,

There was a quick issues which developer have complained. I have now fixed it and below is the response code.

Response:

{
“status”: “success”,
“message”: “All Numbers Fetched”,
“data”: [
{
“productid”: “318667”,
“prodname”: “(208) 208-5555”,
“prodtype”: “1”,
“prodcode”: “pn2082085555”,
“prodfile”: “”,
“proddesc”: “”,
“prodsearchkeywords”: “2082085555”,
“prodavailability”: “unreserved”,
“prodprice”: “4999.9900”,
“prodcostprice”: “0.0000”,
“prodretailprice”: “0.0000”,
“prodsaleprice”: “0.0000”,
“prodcalculatedprice”: “4999.9900”,
“prodsortorder”: “0”,
“prodvisible”: “1”,
“prodfeatured”: “0”,
“prodvendorfeatured”: “0”,
“prodrelatedproducts”: “-1”,
“prodcurrentinv”: “1”,
“prodlowinv”: “0”,
“prodoptionsrequired”: “0”,
“prodwarranty”: “”,
“prodweight”: “0.0000”,
“prodwidth”: “0.0000”,
“prodheight”: “0.0000”,
“proddepth”: “0.0000”,
“prodfixedshippingcost”: “0.0000”,
“prodfreeshipping”: “1”,
“prodinvtrack”: “1”,
“prodratingtotal”: “0”,
“prodnumratings”: “0”,
“prodnumsold”: “0”,
“proddateadded”: “1745005090”,
“prodbrandid”: “10”,
“prodnumviews”: “9”,
“prodpagetitle”: “”,
“prodmetakeywords”: “”,
“prodmetadesc”: “”,
“prodlayoutfile”: “”,
“prodvariationid”: “0”,
“prodallowpurchases”: “1”,
“prodhideprice”: “0”,
“prodcallforpricinglabel”: “”,
“prodcatids”: “183”,
“prodlastmodified”: “1745005090”,
“prodvendorid”: “0”,
“prodhastags”: “0”,
“prodwrapoptions”: “0”,
“prodconfigfields”: “”,
“prodeventdaterequired”: “0”,
“prodeventdatefieldname”: “”,
“prodeventdatelimited”: “0”,
“prodeventdatelimitedtype”: “0”,
“prodeventdatelimitedstartdate”: “0”,
“prodeventdatelimitedenddate”: “0”,
“prodmyobasset”: “”,
“prodmyobincome”: “”,
“prodmyobexpense”: “”,
“prodpeachtreegl”: “”,
“prodcondition”: “New”,
“prodshowcondition”: “0”,
“product_enable_optimizer”: “0”,
“prodpreorder”: “0”,
“prodreleasedate”: “0”,
“prodreleasedateremove”: “0”,
“prodpreordermessage”: “”,
“prodminqty”: “0”,
“prodmaxqty”: “0”,
“tax_class_id”: “1”,
“opengraph_type”: “product”,
“opengraph_title”: “”,
“opengraph_use_product_name”: “1”,
“opengraph_description”: “”,
“opengraph_use_meta_description”: “1”,
“opengraph_use_image”: “1”,
“upc”: “”,
“disable_google_checkout”: “0”,
“prodcarrier”: null,
“prodpin”: null,
“Is_reserved”: “0”,
“reservenumtime”: null,
“brandname”: “New Numbers”
},
{
“productid”: “318666”,
“prodname”: “(626) 550-0000”,
“prodtype”: “1”,
“prodcode”: “pn6265500000”,
“prodfile”: “”,
“proddesc”: “”,
“prodsearchkeywords”: “6265500000”,
“prodavailability”: “unreserved”,
“prodprice”: “3999.9900”,
“prodcostprice”: “0.0000”,
“prodretailprice”: “0.0000”,
“prodsaleprice”: “0.0000”,
“prodcalculatedprice”: “3999.9900”,
“prodsortorder”: “0”,
“prodvisible”: “1”,
“prodfeatured”: “0”,
“prodvendorfeatured”: “0”,
“prodrelatedproducts”: “-1”,
“prodcurrentinv”: “1”,
“prodlowinv”: “0”,
“prodoptionsrequired”: “0”,
“prodwarranty”: “”,
“prodweight”: “0.0000”,
“prodwidth”: “0.0000”,
“prodheight”: “0.0000”,
“proddepth”: “0.0000”,
“prodfixedshippingcost”: “0.0000”,
“prodfreeshipping”: “1”,
“prodinvtrack”: “1”,
“prodratingtotal”: “0”,
“prodnumratings”: “0”,
“prodnumsold”: “0”,
“proddateadded”: “1745005089”,
“prodbrandid”: “10”,
“prodnumviews”: “11”,
“prodpagetitle”: “”,
“prodmetakeywords”: “”,
“prodmetadesc”: “”,
“prodlayoutfile”: “”,
“prodvariationid”: “0”,
“prodallowpurchases”: “1”,
“prodhideprice”: “0”,
“prodcallforpricinglabel”: “”,
“prodcatids”: “102”,
“prodlastmodified”: “1745005089”,
“prodvendorid”: “0”,
“prodhastags”: “0”,
“prodwrapoptions”: “0”,
“prodconfigfields”: “”,
“prodeventdaterequired”: “0”,
“prodeventdatefieldname”: “”,
“prodeventdatelimited”: “0”,
“prodeventdatelimitedtype”: “0”,
“prodeventdatelimitedstartdate”: “0”,
“prodeventdatelimitedenddate”: “0”,
“prodmyobasset”: “”,
“prodmyobincome”: “”,
“prodmyobexpense”: “”,
“prodpeachtreegl”: “”,
“prodcondition”: “New”,
“prodshowcondition”: “0”,
“product_enable_optimizer”: “0”,
“prodpreorder”: “0”,
“prodreleasedate”: “0”,
“prodreleasedateremove”: “0”,
“prodpreordermessage”: “”,
“prodminqty”: “0”,
“prodmaxqty”: “0”,
“tax_class_id”: “1”,
“opengraph_type”: “product”,
“opengraph_title”: “”,
“opengraph_use_product_name”: “1”,
“opengraph_description”: “”,
“opengraph_use_meta_description”: “1”,
“opengraph_use_image”: “1”,
“upc”: “”,
“disable_google_checkout”: “0”,
“prodcarrier”: null,
“prodpin”: null,
“Is_reserved”: “0”,
“reservenumtime”: null,
“brandname”: “New Numbers”
},
{
“productid”: “318665”,
“prodname”: “(217) 217-7000”,
“prodtype”: “1”,
“prodcode”: “pn2172177000”,
“prodfile”: “”,
“proddesc”: “”,
“prodsearchkeywords”: “2172177000”,
“prodavailability”: “unreserved”,
“prodprice”: “3999.9900”,
“prodcostprice”: “0.0000”,
“prodretailprice”: “0.0000”,
“prodsaleprice”: “0.0000”,
“prodcalculatedprice”: “3999.9900”,
“prodsortorder”: “0”,
“prodvisible”: “1”,
“prodfeatured”: “0”,
“prodvendorfeatured”: “0”,
“prodrelatedproducts”: “-1”,
“prodcurrentinv”: “1”,
“prodlowinv”: “0”,
“prodoptionsrequired”: “0”,
“prodwarranty”: “”,
“prodweight”: “0.0000”,
“prodwidth”: “0.0000”,
“prodheight”: “0.0000”,
“proddepth”: “0.0000”,
“prodfixedshippingcost”: “0.0000”,
“prodfreeshipping”: “1”,
“prodinvtrack”: “1”,
“prodratingtotal”: “0”,
“prodnumratings”: “0”,
“prodnumsold”: “0”,
“proddateadded”: “1745005089”,
“prodbrandid”: “10”,
“prodnumviews”: “9”,
“prodpagetitle”: “”,
“prodmetakeywords”: “”,
“prodmetadesc”: “”,
“prodlayoutfile”: “”,
“prodvariationid”: “0”,
“prodallowpurchases”: “1”,
“prodhideprice”: “0”,
“prodcallforpricinglabel”: “”,
“prodcatids”: “140”,
“prodlastmodified”: “1745005089”,
“prodvendorid”: “0”,
“prodhastags”: “0”,
“prodwrapoptions”: “0”,
“prodconfigfields”: “”,
“prodeventdaterequired”: “0”,
“prodeventdatefieldname”: “”,
“prodeventdatelimited”: “0”,
“prodeventdatelimitedtype”: “0”,
“prodeventdatelimitedstartdate”: “0”,
“prodeventdatelimitedenddate”: “0”,
“prodmyobasset”: “”,
“prodmyobincome”: “”,
“prodmyobexpense”: “”,
“prodpeachtreegl”: “”,
“prodcondition”: “New”,
“prodshowcondition”: “0”,
“product_enable_optimizer”: “0”,
“prodpreorder”: “0”,
“prodreleasedate”: “0”,
“prodreleasedateremove”: “0”,
“prodpreordermessage”: “”,
“prodminqty”: “0”,
“prodmaxqty”: “0”,
“tax_class_id”: “1”,
“opengraph_type”: “product”,
“opengraph_title”: “”,
“opengraph_use_product_name”: “1”,
“opengraph_description”: “”,
“opengraph_use_meta_description”: “1”,
“opengraph_use_image”: “1”,
“upc”: “”,
“disable_google_checkout”: “0”,
“prodcarrier”: null,
“prodpin”: null,
“Is_reserved”: “0”,
“reservenumtime”: null,
“brandname”: “New Numbers”
},
{
“productid”: “318664”,
“prodname”: “(772) 771-7777”,
“prodtype”: “1”,
“prodcode”: “pn7727717777”,
“prodfile”: “”,
“proddesc”: “”,
“prodsearchkeywords”: “7727717777”,
“prodavailability”: “unreserved”,
“prodprice”: “3999.9900”,
“prodcostprice”: “0.0000”,
“prodretailprice”: “0.0000”,
“prodsaleprice”: “0.0000”,
“prodcalculatedprice”: “3999.9900”,
“prodsortorder”: “0”,
“prodvisible”: “1”,
“prodfeatured”: “0”,
“prodvendorfeatured”: “0”,
“prodrelatedproducts”: “-1”,
“prodcurrentinv”: “1”,
“prodlowinv”: “0”,
“prodoptionsrequired”: “0”,
“prodwarranty”: “”,
“prodweight”: “0.0000”,
“prodwidth”: “0.0000”,
“prodheight”: “0.0000”,
“proddepth”: “0.0000”,
“prodfixedshippingcost”: “0.0000”,
“prodfreeshipping”: “1”,
“prodinvtrack”: “1”,
“prodratingtotal”: “0”,
“prodnumratings”: “0”,
“prodnumsold”: “0”,
“proddateadded”: “1745005089”,
“prodbrandid”: “10”,
“prodnumviews”: “9”,
“prodpagetitle”: “”,
“prodmetakeywords”: “”,
“prodmetadesc”: “”,
“prodlayoutfile”: “”,
“prodvariationid”: “0”,
“prodallowpurchases”: “1”,
“prodhideprice”: “0”,
“prodcallforpricinglabel”: “”,
“prodcatids”: “81”,
“prodlastmodified”: “1745005089”,
“prodvendorid”: “0”,
“prodhastags”: “0”,
“prodwrapoptions”: “0”,
“prodconfigfields”: “”,
“prodeventdaterequired”: “0”,
“prodeventdatefieldname”: “”,
“prodeventdatelimited”: “0”,
“prodeventdatelimitedtype”: “0”,
“prodeventdatelimitedstartdate”: “0”,
“prodeventdatelimitedenddate”: “0”,
“prodmyobasset”: “”,
“prodmyobincome”: “”,
“prodmyobexpense”: “”,
“prodpeachtreegl”: “”,
“prodcondition”: “New”,
“prodshowcondition”: “0”,
“product_enable_optimizer”: “0”,
“prodpreorder”: “0”,
“prodreleasedate”: “0”,
“prodreleasedateremove”: “0”,
“prodpreordermessage”: “”,
“prodminqty”: “0”,
“prodmaxqty”: “0”,
“tax_class_id”: “1”,
“opengraph_type”: “product”,
“opengraph_title”: “”,
“opengraph_use_product_name”: “1”,
“opengraph_description”: “”,
“opengraph_use_meta_description”: “1”,
“opengraph_use_image”: “1”,
“upc”: “”,
“disable_google_checkout”: “0”,
“prodcarrier”: null,
“prodpin”: null,
“Is_reserved”: “0”,
“reservenumtime”: null,
“brandname”: “New Numbers”
},
{
“productid”: “318663”,
“prodname”: “(747) 774-4444”,
“prodtype”: “1”,
“prodcode”: “pn7477744444”,
“prodfile”: “”,
“proddesc”: “”,
“prodsearchkeywords”: “7477744444”,
“prodavailability”: “unreserved”,
“prodprice”: “1999.9900”,
“prodcostprice”: “0.0000”,
“prodretailprice”: “0.0000”,
“prodsaleprice”: “0.0000”,
“prodcalculatedprice”: “1999.9900”,
“prodsortorder”: “0”,
“prodvisible”: “1”,
“prodfeatured”: “0”,
“prodvendorfeatured”: “0”,
“prodrelatedproducts”: “-1”,
“prodcurrentinv”: “1”,
“prodlowinv”: “0”,
“prodoptionsrequired”: “0”,
“prodwarranty”: “”,
“prodweight”: “0.0000”,
“prodwidth”: “0.0000”,
“prodheight”: “0.0000”,
“proddepth”: “0.0000”,
“prodfixedshippingcost”: “0.0000”,
“prodfreeshipping”: “1”,
“prodinvtrack”: “1”,
“prodratingtotal”: “0”,
“prodnumratings”: “0”,
“prodnumsold”: “0”,
“proddateadded”: “1745005089”,
“prodbrandid”: “10”,
“prodnumviews”: “12”,
“prodpagetitle”: “”,
“prodmetakeywords”: “”,
“prodmetadesc”: “”,
“prodlayoutfile”: “”,
“prodvariationid”: “0”,
“prodallowpurchases”: “1”,
“prodhideprice”: “0”,
“prodcallforpricinglabel”: “”,
“prodcatids”: “110”,
“prodlastmodified”: “1745005089”,
“prodvendorid”: “0”,
“prodhastags”: “0”,
“prodwrapoptions”: “0”,
“prodconfigfields”: “”,
“prodeventdaterequired”: “0”,
“prodeventdatefieldname”: “”,
“prodeventdatelimited”: “0”,
“prodeventdatelimitedtype”: “0”,
“prodeventdatelimitedstartdate”: “0”,
“prodeventdatelimitedenddate”: “0”,
“prodmyobasset”: “”,
“prodmyobincome”: “”,
“prodmyobexpense”: “”,
“prodpeachtreegl”: “”,
“prodcondition”: “New”,
“prodshowcondition”: “0”,
“product_enable_optimizer”: “0”,
“prodpreorder”: “0”,
“prodreleasedate”: “0”,
“prodreleasedateremove”: “0”,
“prodpreordermessage”: “”,
“prodminqty”: “0”,
“prodmaxqty”: “0”,
“tax_class_id”: “1”,
“opengraph_type”: “product”,
“opengraph_title”: “”,
“opengraph_use_product_name”: “1”,
“opengraph_description”: “”,
“opengraph_use_meta_description”: “1”,
“opengraph_use_image”: “1”,
“upc”: “”,
“disable_google_checkout”: “0”,
“prodcarrier”: null,
“prodpin”: null,
“Is_reserved”: “0”,
“reservenumtime”: “4”,
“brandname”: “New Numbers”
}
],
“total_numbers”: “285232”,
“current_offset”: “5”,
“limit”: “5”
}

[Nishit Shan]

in reply to: Maseter Port Out PIN #13815

Hello Andrey,

Thanks for the specific mail with detailed info and special thanks for the developer who sent bug like this proper message. i will check and get back to you .I will do my best to check the API and get back to you with my input.

• This reply was modified 1 month, 1 week ago by Nishit Shan.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13811

Hello Andrey,

I have checked API for order (updateinventory) and it is working, below is the response i got from the API.

API response:
{
“status”: “success”,
“message”: “stock updated”,
“prod”: {
“orderorderid”: 25958,
“ordprodid”: “318598”,
“ordprodsku”: “pn7735145865”,
“ordprodname”: “(773) 514-JUNK”,
“ordprodtype”: “1”,
“ordprodqty”: 1,
“base_price”: “299.9900”,
“price_ex_tax”: “299.9900”,
“price_inc_tax”: “299.9900”,
“price_tax”: 0,
“base_total”: “299.9900”,
“total_ex_tax”: “299.9900”,
“total_inc_tax”: “299.9900”,
“total_tax”: 0,
“base_cost_price”: 0,
“cost_price_inc_tax”: 0,
“cost_price_tax”: 0,
“ordprodweight”: “0.0000”,
“ordprodoptions”: “”,
“ordprodvariationid”: “0”,
“ordprodwrapid”: 0,
“ordprodwrapname”: “”,
“base_wrapping_cost”: 0,
“wrapping_cost_ex_tax”: 0,
“wrapping_cost_inc_tax”: 0,
“wrapping_cost_tax”: 0,
“ordprodwrapmessage”: “”,
“ordprodeventname”: “”,
“ordprodfixedshippingcost”: “0.0000”,
“order_address_id”: 25714,
“applied_discounts”: “”
},
“orderid”: 25958
}

(773) 514-JUNK is product name i have tested for order.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13809

Hello Andrey,

I am testing API for orders , i will test with a lowest price number and will also inform you about that number.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13806

Hello Andrey,

I need a number for testing and your API user can also send me API request code it will help me to get the exact point of error quickly.Because the error log on admin site i can see that the API user proving wrong productId.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13804

Hello Andrey,

select b.brandid, b.brandname, (select count(productid) from cart_products p where p.prodbrandid=b.brandid and p.prodvisible=’1′) as num from cart_brands b order by b.brandname asc;

This above query inside DB log helped little bit for my bug searching. Although there was not any error but code was using old structure as it was made long time ago , so i have optimised the code and updated with new structure .

[Nishit Shan]

in reply to: Maseter Port Out PIN #13802

Hello Andrey,

I have made changes , now please check site speed. I think i have achieved what you was asking .

[Nishit Shan]

in reply to: Maseter Port Out PIN #13800

Hello Andrey,

I have made changes and i can see site loading slightly reduce. You can check from your side also.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13799

Hello Andrey,

I am currently checking queries connected with database.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13796

Hello Andrey,

I have never said the API is involved in front end slow loading in my post #13794, I said customer is providing wrong productid during API request.As i already said and saying it again that slow loading have nothing to do with API. I don’t know why you people are not getting my point , my post #13794 was related to API error not for slow loading .

For the slow loading problem i am still looking for the reason , i have not yet found the exact reason.I am doing my best to get the result .I am also checking the query you sent in log .
I am now working on slow loading problem , i am currently not woring on API.

• This reply was modified 1 month, 1 week ago by Nishit Shan.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13794

Hello Andrey,

error log: https://ibb.co/zhqR2wpY

The provided productid that I can see in the error log does not exist in the ExcellentNumbers database. The maximum productid in our database is 318672, but the API user is using a productid like 5198418, which is incorrect and not available in the database.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13793

Hello Andrey,

I am checking according to your message, i will update you after that.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13778

Hello Andrey,

Could you please share the API path and number that are returning an error? I’ve checked all the APIs on excellentnumbers.net and haven’t found any issues in the API responses. Also, please don’t attribute every error to site speed issues. How do you think site speed could be related to the API? APIs are for third-party use, so how could they impact site speed? I can only investigate if the issue is related to the code.

[Nishit Shan]

in reply to: Maseter Port Out PIN #13769

Hello Andrey,

I checked and compared the code from your old backup and the latest backup, and I didn’t find any major changes that could be causing the site to load slowly.

However, I did find one piece of code also present in the old version,that seems to be blocking the site from rendering after the browser receives the first byte from server. It’s related to index.php?action=tracking_script. This script alone took almost 22 seconds to resolve after the browser received the initial response from the server. Because of this, I’ve temporarily commented out the tracking_script code.

Have you checked the server load recently? Sometimes, web crawlers can add unexpected load to the server during their crawl sessions.
——————————–
also I made changes for the issue https://webmaklay.dev/wp-content/uploads/2025/04/Logs-SQL-errors.jpg

[Author]

Posts