You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
I have both an issue(bug?) and a bit of confusion today regarding the Amazon setup, maybe someone can help me out.
1. When I checked the Amazon Offers last night I had over 17,000 products listed, most duplicates. I ran an SQL statement to delete them all. This morning I have 538 more. I should have about 190 total products.
Is there a setting I messed up that is causing these to continue to download repeatedly and create new products?
2. Why are Amazon ASIN offers tied to 'product offers' and not 'product items'? Am I misunderstanding this? Since an Amazon ASIN is tied to only 1 specific SKU, I am confused as to why a K9 product offer that may have many sku's (product items) of many different sizes, colors, and options would have the "Create on Amazon" option in the product offer setup page?
Offline
(1) The Amazon module should be downloading every ASIN you have listed and mapping one or more identifiers based on the Seller SKU. I'm not sure how it could create duplicates based on the fact that Amazon sends down everything in one shot. How many items are listed on Amazon?
(2) The Amazon offers are mapped using the Seller SKU to the Product Offers in K9 to allow you to list items on Amazon with a Seller SKU matching a Product Offer identifier in K9 and automatically have the inventory mapped correctly. It also allows a quick Amazon offer add from within the Product Offer update in K9. So it's like this to allow you to map both single inventory offers as well as package deals easily based on having matching identifiers.
Offline
Hmmm. I wonder if it's am em-dash and not a standard dash. Do you need an immediate fix for this, or are you able to change those SKUs on the Amazon side? I'm making a note now to look at this prior to releasing the next update.
Offline
I do not need an immediate fix as I am still doing some setup. What does "Review" mean in the System Status column of the Amazon Offers. Most of the duplicates seem to have this as the entry. Side note, I have not connected/ matched many of the listings as I am only now setting up the products in my transition from CCP8. Also, eBay connector has no issues.
Offline
'Review' means you should look at it and make sure it's set up properly because the system had to default something (the SKU in your case). It's a flag so you know to look at it and either remove it, or make changes and update it, or simply update it without making changes (because it's OK).
FYI - if you match your SKUs to your K9 product offer identifiers (ecom_prod.id) everything will auto-match for you when synchronizing initially. And we've just verified dashes are not going to work in those SKUs. I am going to look into that as it should at least be noted somewhere, if not addressed in the code.
Offline
We've been dealing with this since the beginning and have put many hours into trying to get this resolved to no avail. A lot of our SKU's showing in Amazon offers have been deleted from Amazon but still hang up in limbo in K9 as pending delete. I have also tried by deleting them through Raw Database but they simply come back as CHANNELNOMATCH, How can we delete these unneeded sku's if they just keep coming back? Is there a particular procedure for deleting SKU's from both the Amazon listings as well as the K9 Amazon Offers database?
There also seems to be inconsistency with how Amazon FBA orders move through to completed in K9. Most of them remain in pending shipping even though they are FBA and already shipped. Others go to completed showing tracking numbers with no issues. There doesn't seem to be a particular pattern to this to indicate that it is happening only with certain skus and not with others.
Any help is appreciated
Offline
If a SKU is showing as inactive on Amazon and in K9, you can delete it and it will not go through the 'Pending Delete' phase. If you have offers stuck in Pending Delete, you can use these SQL statements to remove them:
SELECT xpricemap FROM ecom_amazonprod WHERE channelitemstatus='Pending Delete'
Take the results of the statement above, and delete all the returned matching ids from the ecom_pricemap table:
DELETE FROM ecom_pricemap WHERE id='PRICEMAP_ID_FROM_ABOVE'
Then delete all the offers:
DELETE FROM ecom_amazonprod WHERE channelitemstatus='Pending Delete'
Concerning FBA, there is a change in release 9.1.0 (pending, in devel now) which properly close out FBA orders - by creating and receiving POs for them and getting tracking back from Amazon. Please apply that update when released to deal with the FBA orders closing out.
Offline
Thank you for this Nick! I'll give this a try.
Offline
Is there an SQL Statement to close out any pending shipment FBA orders to completed?
Thanks
Offline
We have a script that we can run that will do this. Part of the pending 9.1.0 update includes a change to FBA orders to create and receive POs for them and close them out properly.
Offline
Thanks Nick
Offline
Is this a script we can run from our side?
Offline
Part of the pending 9.1.0 update includes a change to FBA orders to create and receive POs for them and close them out properly.
Is this feature available yet or at least for testing??
Offline