Stone Edge mass inventory download

zeev · 2 Joined: 09 Feb 2007 Posts: 884

When I try to perform a mass download of inventory items, it looks like for items that have options, options information does not get created. This information is importent to build all options parameters in SE. This code is easy to write, I wrote some of it and then found out that I can not import XML code to SE. Some of the code looks like this:
<foreach_group_options>
<OptionLists>
<Name>PRODUCT_OPTION_GROUP_NAME</Name>
<foreach_option>
<OptionValue>
<Name>
PRODUCT_OPTION_NUMBER
</Name>
<Prompt>
PRODUCT_OPTION_NAME
</Prompt>
</OptionValue>
</foreach_option>
</OptionLists>
</foreach_group_options>

I will appreciate it if you could add it to your code.

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

SearchFit does provide the options together with the products when SE requests SF via the "downloadprods" action. I just checked and here is a portion of the XML that SF returns to SE for downloadprods. Notice that for your "Soprano Wind Chime" product, SF provides all its options to SE:

zeev · 2 Joined: 09 Feb 2007 Posts: 884

You are absolutely correct on this one. I checked the product and all worked out perfectly on this one.
There are many other products that the options do not transfer.
How do I debug these conditions? Is there a log somewhere?
How can I see the generted XML like the one you provided?
It is importent to have some for of log or error report.
By looking at some products randomely I was under the impression that the code is not there. Now I know that the code is there and is working, but many products do not work properly.
There was another case which I reported when you upload information that alwas has a status of OK which does not allow me to figure out why some data does not upload.

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

When downloading products, here is the SF URL that SE invokes:

https://www.101order.org/jewishbazaar.com/scart/public/services/service_stoneEdge.php?LeaveOnServer=1&setiuser=bazaar&password=XXX&setifunction=downloadprods

Just replace the XXX with your password (Web Services Key).
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

Thanks for the link, that was very helpful. Viewing data always gets you close to a solution. I thing I found the cuase of this problem. When I looked at the data it seemed that the list is too short, so I counted the items in the output and there are exactly 50 items. This meand that you go thru your code only once and finish.
The last statement is </SETIProducts> which means that you go thru your end of input logic.
I believe this is enough information to fix the problem.

When I looked again at a mass import I see more products being imported than 50. How can I see more than 50 items?

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

Just specify the batchsize argument like

https://www.101order.org/jewishbazaar.com/scart/public/services/service_stoneEdge.php?LeaveOnServer=1&setiuser=bazaar&password=XXX&setifunction=downloadprods&batchsize=500
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

That works great. I am convinced that the data that SF creates is good and the problem is on the SE side. I can see SF data that contains options information and it looks good but when the data gets imported to SE I get only product data without options data.
The first items like this is the following and I can not see any problem with it.
- <Product>
<Code>KS-Golfer</Code>
<WebID>177</WebID>
<Name>Golfer - STEEL Sculpture</Name>
<Price>155</Price>
<Cost>0.0000</Cost>
<Description>Each sculpture is hand forged and unique,varying slightly,in shape,surface texture and expression. Made of low carbon Steel</Description>
<Weight>0.000</Weight>
<Thumb>https://www.101order.org/jewishbazaar.com/scart/public/database/product/images_products/golfer-steel-couple-sculpture-t177.jpg</Thumb>
<Image>https://www.101order.org/jewishbazaar.com/scart/public/database/product/images_products/golfer-steel-couple-sculpture-l177.jpg</Image>
<Taxable>Yes</Taxable>
<Discontinued>No</Discontinued>
<QOH>0</QOH>
- <OptionLists>
- <ProductOption>
<WebID>24</WebID>
<Name>Size</Name>
<Prompt>Size</Prompt>
<Type>select</Type>
<default>0</default>
<Required>Yes</Required>
- <OptionValue>
<WebID>28</WebID>
<Name>Select</Name>
<Prompt>Select</Prompt>
<Weight>0.000</Weight>
</OptionValue>
- <OptionValue>
<WebID>25</WebID>
<Name>10 inch</Name>
<Prompt>10 inch</Prompt>
<Code>10</Code>
<Weight>0.000</Weight>
</OptionValue>
- <OptionValue>
<WebID>26</WebID>
<Name>12 inch</Name>
<Prompt>12 inch</Prompt>
<Code>12</Code>
<Weight>0.000</Weight>
</OptionValue>
- <OptionValue>
<WebID>27</WebID>
<Name>14 inch</Name>
<Prompt>14 inch</Prompt>
<Code>14</Code>
<Weight>0.000</Weight>
</OptionValue>
</ProductOption>
</OptionLists>
</Product>

zeev · 2 Joined: 09 Feb 2007 Posts: 884

I noticed that SF data for "OptionValue" is missing "Price" and "Cost".

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

We will add Price and Cost if missing, but you have to check with SE to see why the options are missing on their side.
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

I looked at their developer documentation before I did the post and it shows these fields.
I would love to see additional fields but they are in the documentation, so I do not mention them.

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

I can see in our code that the SF developer handles the Price and Cost elements when the option is configured to have prices. I will need to see later today if they really work.
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

I looked at the generated XML and this code does not get generated.

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

It is generated only for options that use prices. Give me a product of yours that has options with prices?
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

Look at www.giftsofart.com and any item stating with ks-

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

It is time consuming for me to browse your website, please give me an id of a product that I can analyse.
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

Web site www.giftsofart.com
Item KS-Partners Foreign ID 178

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

Found it.

There were really problems with the option prices. I fixed them and updated your server.

Can you please try now?
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

Works great, thank you.

zeev · 2 Joined: 09 Feb 2007 Posts: 884

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

If we don't include the links, are the orders that have product links are actually going to be associated with the regular products by SKU?
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

Once a customer places an order, the order contains only SKU information. It makes no difference if the original item was an item or a link.

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

For now, we will probably fix the links to include the options as well, because some customers might have product links only for some categories.
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

When I download products from one web site, all products from all web sites get downloaded. In other words all web sites are treated as one web site. If this is how it was designed then downloading only the base product is enough.

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

No, that is not true. If you are downloading them all with the same SF user then that is correct. You have to use different user names for each of your websites in order to ask SF to send the appropriate products only.
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

I expected it to work the way you describe it, but it does not. All web sites are treated as one, maybe this is a bug in the software, but that is how it works. I reported a similar issue with inventory updates. When I activated all 4 web sites, I got 4 SF updates for each SE update. My solution was to enable only the main web site and things work OK.

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

I don't know how SE works, but SF will provide the products based on the username that is trying to access that SF URL that SE uses to retrieve the products.

If SE uses the proper username then only the products for that username (think website) will be provided.
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

I setup 4 user names in SE, one for each web site. I use them to download orders and separate them by user id (web site). This works OK. Orders get downloaded separately for each user id. There is also a parameter in per user that allows each user to download orders that belong only to that user.

All other functionality of the SE/SF interface does not seem to be user id sensitive. It sounds like this was not by design (I kind of like it the way it works).
When I ask to perform a function in SE I have to specify which user id/password to use, so SE is userid aware and probaly passes the right information to SF. Note that products in SE are not userid sensitive, only orders are userid sensitive. When information is uploaded to SF then all information for all users will be uploaded and it is SF responsibility to update the right items (I am not sure this can be done). When downloading products to SE, it is SF responsibility to download the correct items (this is not being done, all items are being downloaded).
My guess is that the problem is in SF.

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

SF is designed to go by username and will return only those products for the website.

What is the SF URL you are using?

It does not have to have any uid parameter to allow the passed username to take effect
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com

zeev · 2 Joined: 09 Feb 2007 Posts: 884

For inventory synchronization I use userid of bazaar. (If I enable more userid I get multiple updates).
For any other functionality I use any userid of the four I have. Most of the time I use userid bazaar.

zeev · 2 Joined: 09 Feb 2007 Posts: 884

Any idea when next release will be available?
I am waiting on a solution for this issue.

stanley@searchfit · 2 Joined: 23 Jan 2003 Posts: 6423 Location: Austin, TX

This was resolved and next release is scheduled mid March for now.
_________________
Stanley Stanev
SearchFit Architect
www.searchfit.com
www.searchfit.us.com
www.stanev.com
www.yordanova.com