Kryptronic Software Support Forum

NOTE: This post was created on 2023-07-20 on the Kryptronic eCommerce Community facebook page, which has been replaced with this forum.  All facebook support content was migrated into this forum in April 2024.

Evan:

We are having issues with channels such as Amazon and Walmart not updating after a "pending delete" or "pending insert" status. Amazon shows active listings with certain items but K9 shows "pending insert" status and won't allow for any editing in this state. Walmart has "pending insert" for items for several weeks that never actually seem to get listed on Walmart nor any status as to how we can resolve this.

Evan:

Frank, any suggestions? 😊

Nick:

Walmart actually has humans process all requests, and they generally handle 20% of them correctly within about 24-48 hours, and the remainder are either left undone or done wrong. The best course of action there is to remove your item from the software then attempt to re-add it an cross your fingers. If offers get stuck, remove and try again. I know it's not optimal, but either is Walmart's system.

Evan:

Is this the case with Amazon also? It seems I can delete an item through K9 and it actually deletes in Amazon yet the dialog in K9 says pending delete and stays stuck on that message

Evan:

Should I delete them directly in the raw database since the interface doesn't allow me to make changes in this state?

Evan:

Also, Does Walmart download orders that are Walmart Fulfilled as well as self-fulfilled? We want to see if the order export to K9 at least imports the orders. Thank

Nick:

Amazon is not the same as Walmart. It is a good system. If you have an item hung as pending delete for Amazon and it has been removed from Amazon, you can force the delete by running:

DELETE FROM ecom_amazonprod WHERE id='AMAZON-OFFER-ID'

DELETE FROM ecom_pricemap WHERE channelid='AMAZON' AND xofferid='AMAZON-OFFER-ID'

As far as Walmart orders being downloaded, I don't have an answer regarding Walmart Fulfilled orders - that's a new thing. I assume they would download and would need to be marked as shipped. Please let me know what you see happening there.

Evan:

Do I run this statement as is or replace 'AMAZON-OFFER-ID' with the item sku value?

Nick:

Replace AMAZON-OFFER-ID with the sku