Export Products to eBay: empty eBay Category

[Xue-Feng Yang]

Hi all,

I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However, there is nothing inside. 

What is the rule to have eBay Category? I googled, but found nothing.

I would be appreciated if anyone could help.

Thanks,

Xuefeng

[Jacques Le Roux]

It's half baked stuff. IIRW I was able to test that complety once (some years ago)
But I can't find any notes, nor in our ML, with http://ofbiz.markmail.org/search/?q=Export+Products+to+eBay
only noticed
http://markmail.org/message/fzxtrszh3bk7ipdk
http://markmail.org/message/hrufslnlldkiqp6i
http://markmail.org/message/mzkttzr6buitcfmu
http://markmail.org/message/5c4najhfd4kk4465

HTH

Jacques

On Wednesday, February 05, 2014 11:01 PM, [hidden email] wrote

> Hi all,
>
> I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However,
> there is nothing inside.
>
> What is the rule to have eBay Category? I googled, but found nothing.
>
> I would be appreciated if anyone could help.
>
> Thanks,
>
> Xuefeng

[Xue-Feng Yang]

Thank you Jacques. Although it sounds very bad, I'll try more on this. At least, I saw some info in Ofbiz related my account from eBay when setup a store. 

Xuefeng


On Thursday, February 6, 2014 6:48:57 AM, Jacques Le Roux <[hidden email]> wrote:
 
It's half baked stuff. IIRW I was able to test that complety once (some years ago)
But I can't find any notes, nor in our ML, with http://ofbiz.markmail.org/search/?q=Export+Products+to+eBay
only noticed
http://markmail.org/message/fzxtrszh3bk7ipdk
http://markmail.org/message/hrufslnlldkiqp6i
http://markmail.org/message/mzkttzr6buitcfmu
http://markmail.org/message/5c4najhfd4kk4465

HTH

Jacques

On Wednesday, February 05, 2014 11:01 PM, [hidden email] wrote

> Hi all,
>
> I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However,
> there is nothing inside.
>
> What is the rule to have eBay Category? I googled, but found nothing.
>
> I would be appreciated if anyone could help.
>
> Thanks,
>
> Xuefeng

[Xue-Feng Yang]

Hi Jacques:

You may know the meaning of the following error message:

The Following Errors Occurred:
The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: 
Failure in create operation for entity [ProductCategoryRole]: org.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:ProductCategoryRole][comments,609549(java.lang.String)]
[createdStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[createdTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[fromDate,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[partyId,DemoEbayAccount1(java.lang.String)]
[productCategoryId,eBay_Category(java.lang.String)]
[roleTypeId,EBAY_ACCOUNT(java.lang.String)] 
(SQL Exception while executing the following:
INSERT INTO PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry 'eBay_Category-DemoEbayAccount1-EBAY_ACCOUNT-2014-02-06 22:13:10' for key 'PRIMARY')
). 
Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:ProductCategoryRole][comments,609549(java.lang.String)]
[createdStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[createdTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[fromDate,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[partyId,DemoEbayAccount1(java.lang.String)]
[productCategoryId,eBay_Category(java.lang.String)]
[roleTypeId,EBAY_ACCOUNT(java.lang.String)] 
(SQL Exception while executing the following:INSERT INTO PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry 'eBay_Category-DemoEbayAccount1-EBAY_ACCOUNT-2014-02-06 22:13:10' for key 'PRIMARY')
) (Error while inserting: [GenericEntity:ProductCategoryRole]
[comments,609549(java.lang.String)]
[createdStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[createdTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[fromDate,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[partyId,DemoEbayAccount1(java.lang.String)]
[productCategoryId,eBay_Category(java.lang.String)]
[roleTypeId,EBAY_ACCOUNT(java.lang.String)] 
(SQL Exception while executing the following:INSERT INTO PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry 'eBay_Category-DemoEbayAccount1-EBAY_ACCOUNT-2014-02-06 22:13:10' for key 'PRIMARY')
)
   )

Thanks

[Xue-Feng Yang]

Here is the most recent testing result in log.

13:49:48,763 (http-bio-0.0.0.0-8443-exec-10) [     RequestHandler.java:661:INFO ] Ran Event [service:#exportToEbay] from [request], result is [success]
13:49:48,766 (http-bio-0.0.0.0-8443-exec-10) [       SequenceUtil.java:348:INFO ] Got bank of sequenced IDs for [ServerHitBin]; curSeqId=10130, maxSeqId=1014

13:49:48,768 (http-bio-0.0.0.0-8443-exec-10) [     RequestHandler.java:763:INFO ] Rendering View [ProductsExportToEbay], sessionId=BCD04207ED463B5820F60CC22F

13:49:48,830 (http-bio-0.0.0.0-8443-exec-10) [      ScreenFactory.java:130:INFO ] Got 10 screens in 0.005s from: file:/C:/Programs/ofbiz/specialpurpose/ebay/

It looks successful. However, neither the ofbiz page show anything, nor ebay sandbox show any new list. It's not successful with the word "success".

Any thought?




On Wednesday, February 5, 2014 5:04:42 PM, Xue-Feng Yang <[hidden email]> wrote:
 
Hi all,

I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However, there is nothing inside. 

What is the rule to have eBay Category? I googled, but found nothing.

I would be appreciated if anyone could help.

Thanks,

Xuefeng

[Xue-Feng Yang]

I just found the newest eBay java SDK version for ofbiz is 635, but current eBay release is 849. Sounds interesting. So I will go SDK 849 first and back to ofbiz code later to fix the problems. 



On Saturday, February 8, 2014 2:06:07 PM, Xue-Feng Yang <[hidden email]> wrote:
 
Here is the most recent testing result in log.

13:49:48,763 (http-bio-0.0.0.0-8443-exec-10) [     RequestHandler.java:661:INFO ] Ran Event [service:#exportToEbay] from [request], result is [success]
13:49:48,766 (http-bio-0.0.0.0-8443-exec-10) [       SequenceUtil.java:348:INFO ] Got bank of sequenced IDs for [ServerHitBin]; curSeqId=10130, maxSeqId=1014

13:49:48,768 (http-bio-0.0.0.0-8443-exec-10) [     RequestHandler.java:763:INFO ] Rendering View [ProductsExportToEbay], sessionId=BCD04207ED463B5820F60CC22F

13:49:48,830 (http-bio-0.0.0.0-8443-exec-10) [      ScreenFactory.java:130:INFO ] Got 10 screens in 0.005s from: file:/C:/Programs/ofbiz/specialpurpose/ebay/

It looks successful. However, neither the ofbiz page show anything, nor ebay sandbox show any new list. It's not successful with the word "success".

Any thought?





On Wednesday, February 5, 2014 5:04:42 PM, Xue-Feng Yang <[hidden email]> wrote:

Hi all,

I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However, there is nothing inside. 

What is the rule to have eBay Category? I googled, but found nothing.

I would be appreciated if anyone could help.

Thanks,

Xuefeng