Rajeev,
Here are tables that you need to look up for Products setting.
<ProdCatalog prodCatalogId="DemoCatalog" catalogName="Demo Catalog"
useQuickAdd="Y"/>
<ProductStoreCatalog productStoreId="10000" prodCatalogId="DemoCatalog"
fromDate="2001-05-13 12:00:00.0" sequenceNum="1"/>
<ProductCategory categoryName="Demo Browse Root" productCategoryId=
"DEMO_BRWS_ROOT" description="Demo Browse Root"
productCategoryTypeId="CATALOG_CATEGORY"/>
<ProdCatalogCategory prodCatalogId="DemoCatalog" productCategoryId=
"DEMO_BRWS_ROOT" fromDate="2001-05-13 12:00:00.0" sequenceNum="1"
prodCatalogCategoryTypeId="PCCT_BROWSE_ROOT"/>
<ProdCatalogCategory prodCatalogId="DemoCatalog" productCategoryId=
"PROMOTIONS" fromDate="2001-05-13 12:00:00.0" sequenceNum="1"
prodCatalogCategoryTypeId="PCCT_PROMOTIONS"/>
<ProductCategory productCategoryId="DEMO" categoryName="Demo Category"
description="Demo Main Category"
primaryParentCategoryId="DEMO_BRWS_ROOT" productCategoryTypeId=
"CATALOG_CATEGORY"/>
<Product productId="Demo-101" productTypeId="DIGITAL_GOOD"
primaryProductCategoryId="DEMO_BRWS_ROOT" productName="Demo PC"
internalName="Demo PC" description="Demo PC" taxable="Y"
chargeShipping="N" autoCreateKeywords="Y" isVirtual="N" isVariant="N"
createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
lastModifiedDate="2001-05-13 12:00:00.0" lastModifiedByUserLogin="admin">
<longDescription><![CDATA[ ]]></longDescription>
</Product>
<ProductPrice productId="Demo-101" productPricePurposeId="PURCHASE"
productPriceTypeId="DEFAULT_PRICE" currencyUomId="USD"
productStoreGroupId="_NA_" fromDate="2001-05-13 12:00:00.0" price="99"
createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
lastModifiedDate="2001-05-13 12:00:00.0" lastModifiedByUserLogin="admin"/>
<ProductPrice productId="Demo-101" productPricePurposeId="PURCHASE"
productPriceTypeId="LIST_PRICE" currencyUomId="USD" productStoreGroupId=
"_NA_"
fromDate="2001-05-13 12:00:00.0" price="99" createdDate="2001-05-13
12:00:00.0" createdByUserLogin="admin" lastModifiedDate="2001-05-13
12:00:00.0"
lastModifiedByUserLogin="admin"/>
<ProductCategoryMember productCategoryId="DEMO_BRWS_ROOT" productId=
"Demo-101" fromDate="2001-05-13 12:00:00.0"/>
I hope it will be useful for you.
On 6/18/08, Raj Saini <[EMAIL PROTECTED]> wrote:
>
> Rajeev,
>
> It depends on which format your product database is available. Entity
> engine import is the best and it works like a charm. You will need to have
> your products in entity-engine format file. You can look at the demo data in
> the e-commerce component how data is formatted in xml.
>
> Other option is use cvs. There is a datafile tool in webtools. I have not
> played much with it but you can find more information on Nabble or Google.
>
> Thanks,
>
> Raj
>
> Rajeev Gupta wrote:
>
>> We have about 10000 products. What's the best way to add these many
>> products? Could some body guide about the tables that we need to look up?
>>
>> Is there any product import tool?
>>
>>
>>
>> u
>>
>
>
--
Anil Soni
Software Engineer
Amicon Technologies Private Limited
6th Floor - Unique Tower, Behind Patel Patrol Pump,
Goregaon (W), Mumbai MH
Contact no.- +91-9892271357
