using excel for uploading product inventory

hello

what are the following fields in the excel sheet for uploading products

cycle length

cycle period

total cycles

also how do we add size and colour attributes for products using the spreadsheet.

is it possible to connect directly to the database and transfer records from our own database,

we have a database of products on the client machine which we keep updated

what we would like to do is transfer records from our database to web site database using sql

regards,

lubish wrote:
RecurringCycleLength
RecurringCyclePeriodId
RecurringTotalCycles

You should Export  to Excel to see the fields/format expected of the Import (use a demo sys if you need to)

lubish wrote:
Attributes are not supported in the Import/Export.

lubish wrote:
Yes, but you must have an understanding of the table relationships - e.g. for variants, ProductVariant.ProductId must be set to its parent Product.Id - the challenge is that the Product.Id is a surrogate key / SQL Identity column, which gets auto-generated.

does that mean excel cannot be used to upload products with size and colour attributes

regards,