Updating Product Options Via API

The AbleCommerce data exchange is a useful feature for importing and updating data. The Data Exchange feature (just like the 7.0.x data port) is only supported via the forums or paid support.

*** BACKUP YOUR DATABASE BEFORE ATTEMPTING TO USE THESE TOOLS ***
Post Reply
AndreiN
Ensign (ENS)
Ensign (ENS)
Posts: 1
Joined: Tue Aug 20, 2013 1:17 pm

Updating Product Options Via API

Post by AndreiN » Wed Aug 21, 2013 12:36 pm

Hello,

This is my first post, and I couldn't quite figure out under what category to place my question, so here goes nothing. Moderators, please be merciful :P

I have written a service, using ASp.NET & C#, that allows me to update products in the AbleCommerce webstore. But I would like to be able to update product options and variants as well - all via API calls within my service, not by using the DataPort utility. The XML that I currently submit via a POST follows the following structure:

=========================================

<?xml version="1.0" encoding="utf-8"?>
<AbleCommerceExport>
<Store>
<Products>
<Product>
<ProductId>0</ProductId>
<StoreId>1</StoreId>
<Name>10' PS/2 Extension Cable</Name>
<Price>11.99</Price>
<CostOfGoods>0</CostOfGoods>
<MSRP>15.95</MSRP>
<Weight>0.10</Weight>
<Length>2.00</Length>
<Width>2.00</Width>
<Height>4.00</Height>
<ManufacturerId>6</ManufacturerId>
<Manufacturer>Belkin</Manufacturer>
<Sku>F2N035-10</Sku>
<ModelNumber />
<DisplayPage />
<TaxCodeId>1</TaxCodeId>
<TaxCode>Taxable</TaxCode>
<ShippableId>1</ShippableId>
<Shippable>Yes</Shippable>
<WarehouseId>2</WarehouseId>
<Warehouse>Default Warehouse</Warehouse>
<InventoryModeId>0</InventoryModeId>
<InStock>0</InStock>
<InStockWarningLevel>0</InStockWarningLevel>
<ThumbnailUrl>~/Assets/images/icon_box_closed.gif</ThumbnailUrl>
<ThumbnailAltText>10' PS/2 Extension Cable</ThumbnailAltText>
<ImageUrl>~/Assets/images/icon_box_closed.gif</ImageUrl>
<ImageAltText>10' PS/2 Extension Cable</ImageAltText>
<Summary />
<Description></Description>
<VendorId>0</VendorId>
<CreatedDate>2009-07-28T17:29:34</CreatedDate>
<LastModifiedDate>2009-09-18T04:23:02</LastModifiedDate>
<ProductTemplateId>0</ProductTemplateId>
<IsFeatured>false</IsFeatured>
<IsProhibited>false</IsProhibited>
<AllowReviews>false</AllowReviews>
<AllowBackorder>false</AllowBackorder>
<WrapGroupId>2</WrapGroupId>
<WrapGroup>Small Packages</WrapGroup>
<ExcludeFromFeed>false</ExcludeFromFeed>
<DisablePurchase>false</DisablePurchase>
<MinQuantity>0</MinQuantity>
<MaxQuantity>0</MaxQuantity>
<VisibilityId>0</VisibilityId>
<Theme />
<IconUrl />
<IconAltText>10' PS/2 Extension Cable</IconAltText>
<IsGiftCertificate>false</IsGiftCertificate>
<CouponProduct />
<ExtendedDescription />
<HtmlHead />
<UseVariablePrice>false</UseVariablePrice>
<MinimumPrice>0</MinimumPrice>
<MaximumPrice>0</MaximumPrice>
<SearchKeywords />
<HidePrice>false</HidePrice>
<Categories>
<Category>
<CategoryId>40</CategoryId>
<Path>Accessories:Cables</Path>
<OrderBy>-1</OrderBy>
</Category>
</Categories>
</Product>
</Products>
</Store>
</AbleCommerceExport>

=========================================

Unfortunately however, I am having a very hard time finding information on what the XML structure of any other kind of updates might be.

Is there any way to specify a product's options within this XML structure? Such as for example "Products/Product/ProductOptions/ProductOption/..." ? Is there some other call that can be made that will create/update options and variants for a particular product?

Any help would be appreciated. Please let me know if any more details are required in order to answer my question.

Thank you!

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2649
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Updating Product Options Via API

Post by Katie » Wed Aug 21, 2013 8:48 pm

Hi, and welcome to the forums!

I might be able to point you in the right direction, but we need to know which version of AbleCommerce you're working with. Is it version 7.0.7 or Gold. The reason I ask is that we have built-in dataport options in the latest version of Gold, and that included a Product Options import. The Dataport utility (client app) works specifically with version 7.0.7. I just want to clarify...

Thanks!
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

jdn717
Ensign (ENS)
Ensign (ENS)
Posts: 9
Joined: Mon Mar 24, 2014 1:12 pm

Re: Updating Product Options Via API

Post by jdn717 » Thu Apr 03, 2014 3:12 pm

AndreiN


Would you please share what libraries you are using to update products?

Post Reply