Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] osc2ebay - oscommerce to ebay synchronization


hozone

Recommended Posts

Hi,

 

Can you give a little more information on what this mod does and how it operates?

 

Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

hello.

 

This contribution is completely web-based, it use SOAP and the ebay API to synchronize items.

please look at http://developer.ebay.com/devzone/xml/docs/reference/ebay/index.html for ebay API documentation.

 

it requires small changes to work.

osCommerce Italia support: http://www.oscommerceitalia.com

Link to comment
Share on other sites

I tried to implement this addon and I'm working on local server(wamp). I'm getting the error like SOAP-ERROR :failed to load external entity. Pls help...

Can anyone give a detailed installation steps and requirements for this addon.

 

Thanks in advance..

Surya

Link to comment
Share on other sites

  • 2 weeks later...

I recive some errors:

 

When i click on ebay Sync Items (this is from adnim menu in left): Warning: Invalid argument supplied for foreach() in /home/kinyx/worldcleaningproducts.com/admin2008/ebay_syncitems.php on line 644

 

When click on Ebay Only items: Warning: Invalid argument supplied for foreach() in /home/kinyx/worldcleaningproducts.com/admin2008/ebay_syncitems.php on line 242

 

When click on AutoLink Ebay items: Warning: Invalid argument supplied for foreach() in /home/kinyx/worldcleaningproducts.com/admin2008/ebay_syncitems.php on line 299

 

 

Thx for help!!

Edited by realdark
Link to comment
Share on other sites

  • 3 weeks later...
  • 3 weeks later...

I have come a long way in getting rid of stupid issues i was having with installation of this wonderful addon.

now i am having two issues

1-although categories are downloaded from ebay and entered in the db table. it does not show in the categories drop down form.

2-when i want to add an item i get the following error

Response:
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <soapenv:Body>
  <soapenv:Fault>
<faultcode xmlns:ns1="http://xml.apache.org/axis/">ns1:Server</faultcode>
<faultstring>Input data is invalid.</faultstring>
<faultactor>http://www.ebay.com/ws/websvc/eBayAPI</faultactor>
<detail>
 <FaultDetail>
  <ErrorCode>37</ErrorCode>
  <Severity>Error</Severity>
  <DetailedMessage>Input data for tag <Item.Site> is invalid or missing. Please check API documentation.</DetailedMessage>
 </FaultDetail>
</detail>
  </soapenv:Fault>
 </soapenv:Body>
</soapenv:Envelope>

Edited by tedbooks
Link to comment
Share on other sites

Hi,

 

Seems like a really great contribution that is much needed by many users of oscommerce. To test 'osc2ebay' I have installed a fresh installation OSC 2.2 and used all the supplied patched files and updated the config file to what I believe is correct.

 

The only problem is I can not get past the following error when trying to 'Add an item to eBay':

 

I receive this response:

 

Response:

<?xml version="1.0" encoding="UTF-8"?>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<faultcode xmlns:ns1="http://xml.apache.org/axis/">ns1:Server</faultcode>

<faultstring>Input data is invalid.</faultstring>

<faultactor>http://www.ebay.com/ws/websvc/eBayAPI</faultactor>

<detail>

<FaultDetail>

<ErrorCode>37</ErrorCode>

<Severity>Error</Severity>

<DetailedMessage>Input data for tag &lt;Item.Storefront.StoreCategoryID> is invalid or missing. Please check API documentation.</DetailedMessage>

</FaultDetail>

</detail>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

 

 

 

And when I go to "ebay Get Categories" in OSC admin and click on "Update Categories" button I get the following:

 

12493 categories inserted successfully!

get store categories error

 

"Back To Products Page" "Back"

 

 

 

When I then go back to "ebay Get Categories" in OSC admin there is the following:

 

 

current categories - Drop down box with many categories

current store categories - Drop down box empty

 

 

 

Please can you help?

 

 

 

Many Thanks,

Jamie

 

post-312104-0-33704700-1338082672_thumb.jpg

post-312104-0-16650400-1338082360_thumb.jpg

Link to comment
Share on other sites

it is probably because you have no store category. maybe!! just add something in the data base and see if it works.

​ suggestion for Hozone

a- ability to add an item as auction

b-ability to deal with the sale from the store like feedback adding tracking number and so on

c-ability to limit the categories in ebay_addproducts.php it might be done by adding a drop down of primary categories in the beginning like the attributes.

 

this is one great addon and i really am loving it. thank you

Edited by tedbooks
Link to comment
Share on other sites

"it is probably because you have no store category. maybe!! just add something in the data base and see if it works."

 

Unfortunately not, as I have tried it with the default categories that come supplied with OSC 2.2 RC2 and have also tried again after adding some new categories and products. Have also tried on 2 servers 1 running php 5.2.9 and the other 5.3 but still get the same errors - I have been told SOAP is installed and enabled. Will probably be something really simple but I'm not really much of an expert with this sort of thing.

 

Does it matter what version the 'eBaySvc.wsdl' file is?

 

 

Thanks,

Jamie

Edited by stephens210180
Link to comment
Share on other sites

Unfortunately not, as I have tried it with the default categories that come supplied with OSC 2.2 RC2 and have also tried again after adding some new categories and products. Have also tried on 2 servers 1 running php 5.2.9 and the other 5.3 but still get the same errors - I have been told SOAP is installed and enabled. Will probably be something really simple but I'm not really much of an expert with this sort of thing.

 

 

Thanks,

Jamie

no store category in ebay or no ebay store

try adding a category to ebay_categoriesstore table

or comment out these lines in ebay_addproducts.php

// 'Storefront' => array(
 //  'StoreCategory2ID' => $StoreCategoryID,
 //  'StoreCategoryID' => $StoreCategoryID
 //  ),

Edited by tedbooks
Link to comment
Share on other sites

no store category in ebay or no ebay store

try adding a category to ebay_categoriesstore table

or comment out these lines in ebay_addproducts.php

// 'Storefront' => array(
 //  'StoreCategory2ID' => $StoreCategoryID,
 //  'StoreCategoryID' => $StoreCategoryID
 //  ),

 

 

Thanks Ted, making progress now.

 

Added some categories in my ebay store and the errors I was getting have now gone and the categories added on ebay are now in Showing up in my OSC website.

 

 

I now get the following when adding a product (in oscommerce admin) to ebay:

 

 

ebay Add Item pixel_trans.gif Errors

 

Catchable fatal error: Object of class stdClass could not be converted to string in/home/comput4/public_html/back/ebay_addproducts.php on line 170

 

The code is:

 

 

print "Errors<br />";

if($results->Errors != null)

foreach($results->Errors as $key => $value)

if($key == "LongMessage") echo $value."<br />";

echo "<br />";

 

 

 

If I comment this code out I get the request and the following Response:

 

 

 

Response:

<?xml version="1.0" encoding="UTF-8"?>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<AddItemResponse xmlns="urn:ebay:apis:eBLBaseComponents">

<Timestamp>2012-05-30T15:21:03.229Z</Timestamp>

<Ack>Failure</Ack>

<Errors>

<ShortMessage>Shipping service is not available.</ShortMessage>

<LongMessage>Shipping service Corriere espresso(10110) is not available.</LongMessage>

<ErrorCode>12519</ErrorCode>

<SeverityCode>Error</SeverityCode>

<ErrorParameters ParamID="0">

<Value>Corriere espresso(10110)</Value>

</ErrorParameters>

<ErrorClassification>RequestError</ErrorClassification>

</Errors>

<Errors>

<ShortMessage>Shipping service is not available.</ShortMessage>

<LongMessage>Shipping service Ritiro in zona(10151) is not available.</LongMessage>

<ErrorCode>12519</ErrorCode>

<SeverityCode>Error</SeverityCode>

<ErrorParameters ParamID="0">

<Value>Ritiro in zona(10151)</Value>

</ErrorParameters>

<ErrorClassification>RequestError</ErrorClassification>

</Errors>

<Version>773</Version>

<Build>E773_INTL_BUNDLED_14839591_R1</Build>

</AddItemResponse>

</soapenv:Body>

</soapenv:Envelope>

 

 

 

Any ideas on what the cause of this problem maybe please?

Again thanks for your help.

 

 

 

Many Thanks,

Jamie

Link to comment
Share on other sites

are the shipping method correct for your ebay?

 

It does look like that is what the error is pointing to, unfortunately I have not had an ebay store before (only sold 1 or 2 things on ebay in the past) so am a little unsure what is the minimum amount of configuration required with this contribution and on ebay to get to the stage where I am able to test the basics of this great contibution.

 

Like adding the categories in my ebay store do I need to change / add shipping details some where on ebay or even on OSC? Shipping is set to flat rate in OSC admin.

 

Seems like I'm nearly there and this is possibly the last hurdle to get over before I can get some products from my osc store across to my ebay store.

 

Any more advice will be much welcomed.

 

 

My main store will be OSC v2.3.1 but I am also trying this on OSC v2.2 RC2 at the same time.

 

 

Thanks,

Jamie

Link to comment
Share on other sites

http://developer.ebay.com/devzone/xml/docs/Reference/eBay/types/ShippingServiceCodeType.html

you must use the correct code for shipping.

i think that was the error that you posted

Edited by tedbooks
Link to comment
Share on other sites

http://developer.ebay.com/devzone/xml/docs/Reference/eBay/types/ShippingServiceCodeType.html

you must use the correct code for shipping.

i think that was the error that you posted

 

 

Yep, got it working last night!!!

 

Noticed there were a few more bits of code and tags that were for Italy so change all to the UK versions such as for example (for others who may come across this problem):

 

 

In 'catalog/admin/ebay_addproducts

 

"IT_ExpressCourier" change to the shipping in your company - I use "UK_RoyalMailFirstClassRecorded"

Also change all other "IT....." references if your store in not in Italy to the correct ones for your country.

 

 

 

Helpful sites:

 

http://developer.ebay.com/devzone/xml/docs/Reference/eBay/types/ShippingServiceCodeType.html

 

http://developer.ebay.com/DevZone/XML/docs/WebHelp/wwhelp/wwhimpl/common/html/wwhelp.htm?context=eBay_XML_API&file=FieldDifferences-Site_IDs.html

 

 

 

Thanks for the great contribution hozone and thanks Ted for your help.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...