Uploading NEW Products with Variants + other fields

A forum where issues related to the DataPort utility can be discussed.
Post Reply
TyMorris
Ensign (ENS)
Ensign (ENS)
Posts: 13
Joined: Fri Jun 05, 2009 5:49 am

Uploading NEW Products with Variants + other fields

Post by TyMorris » Tue Jul 13, 2010 9:22 am

Hi,

I would like to upload new products with variants. However, in addition to the fields provided, I want to add fields that are seen in a Product Upload ( Description, Summary, Vendor, Search Keywords, etc) without variants. When I try to do a Variant Upload with additional fields, they are not recognized. Can someone please help me???? I'm basically looking to marry the Product Upload fields and the Product Variant Upload fields. My goal is to mass upload my new products and have as many fields as possible uploaded. Any help would be MUCH appreciated!

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Uploading NEW Products with Variants + other fields

Post by Naveed » Wed Jul 14, 2010 8:35 am

Please look at this related article:

http://wiki.ablecommerce.com/index.php/ ... riants_CSV

TyMorris
Ensign (ENS)
Ensign (ENS)
Posts: 13
Joined: Fri Jun 05, 2009 5:49 am

Re: Uploading NEW Products with Variants + other fields

Post by TyMorris » Wed Jul 14, 2010 10:47 am

Thanks Naveed-- I did read that article a little bit ago, which brought me to the original question I posted; It is possible to add ADDITIONAL fields to the Product Variant Upload other than the ones listed on that wiki article? For example, I'd like to have a Summary field, Description, Search Keywords, etc ...and all the other fields listed in the Original Product CSV Upload, listed below:

ProductId
StoreId
Name
Price
CostOfGoods
MSRP
Weight
Length
Width
Height
Manufacturer
Sku
ModelNumber
DisplayPage
TaxCode
Shippable
WarehouseId
Warehouse
InventoryModeId
InStock
InStockWarningLevel
ThumbnailUrl
ThumbnailAltText
ImageUrl
ImageAltText
Summary
Description
ExtendedDescription
Vendor
CreatedDate
LastModifiedDate
ProductTemplate
IsFeatured
IsProhibited
AllowReviews
AllowBackorder
WrapGroup
ExcludeFromFeed
HtmlHead
DisablePurchase
MinQuantity
MaxQuantity
VisibilityId
Theme
IconUrl
IconAltText
IsGiftCertificate
Categories
UseVariablePrice
MinimumPrice
MaximumPrice
SearchKeywords
HidePrice


My goal is to use these fields as well in uploading items (I have several thousand to do).
Thanks

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Uploading NEW Products with Variants + other fields

Post by Naveed » Mon Jul 19, 2010 7:14 am

It is possible to add ADDITIONAL fields to the Product Variant Upload other than the ones listed on that wiki article? For example, I'd like to have a Summary field, Description, Search Keywords, etc ...and all the other fields listed in the Original Product CSV Upload,
It seems not possible. If you want to import complete data for a product then you have to use standard product import (upload). After importing product data you can then import variants data for those product in 2nd phase using the Variants CSV import (upload) feature.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Uploading NEW Products with Variants + other fields

Post by jmestep » Mon Jul 19, 2010 4:19 pm

I have done it from a csv file that had both product and variant data in it.
First I did the variants and it did the basic product data also.
Then I changed the names on some of the headers in the file to match the product upload, then uploaded the rest of the product data using the sku to match the records in the dataport configuration. That eliminated the need to try to match up the variants with a product id by doing the upload in the reverse order.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
RichWendrock
Commander (CMDR)
Commander (CMDR)
Posts: 134
Joined: Sat Apr 05, 2008 12:55 am
Location: Austin Texas
Contact:

Re: Uploading NEW Products with Variants + other fields

Post by RichWendrock » Mon Aug 02, 2010 8:09 am

Has anyone found a way to upload the product description and head fields when batch adding products?

Thanks Ahead of time for your help...

Take Care,
Rich
Regards,
Richard

http://www.TheHomePageStore.com

AbleCommerce
VERSION: 7.0.7.14588
MSSQL v2005
AC SCHEMA v2005
.NET CLR v2.0.50727.3634

Post Reply