Importing and Subproducts

 

We are fairly new to PC and acutally purchased it last year.  Due to some issues with family we had to delay.

 

I have done a lot of reading on here and was wondering if anyone know how I can get what we need done.

 

We currently have about 1300 Parent products to import with those parent products carrying a combined total of 26k sub products. 

 

From what we can tell by playing with PC and in the Wiki, the Atrributes are uploaded with the partent products, then assigned when the subproducts are uploaded.  This is where our problem come in.  For the files we get from one of our vendors, they break down parent products on one line, and the each sub product has its own line with the attributes there.  They do not list all attribues with the parent products.

 

Parent Example:

SKU     Number

Display Name

UPC

Size

Color

Price

MSRP

Description

WID

Widgets

7.2800

9.99

Works with Anything

 

 

Sub Product Example:

SKU  Number

Display Name

UPC

Size

Color

Price

MSRP

Description

 

WID	Large Blue Widget	00010	Large	Blue	7.2800	9.99	Large Blue
WID	Small Gree Widget	00020	Small	Green	7.2800	9.99	Small Green

 

 

 

 

I hope this makes sense to everyone and hope someone has a solution as I cant see myslef manually updating the spreadsheet to cover every sub product for each of the 1300 parents

 

 

Thanks in advance

Adam

 

 

Thank you for such a quick response.  Could you please give me an estimate on price range based on the info I provided.  We get updates from this vendor once a week with stock levels and product updates.  If this works we may need assistance with other vendors that we have yet to try in PC.

 

Thanks again

Adam