You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Rajeev Gupta <ra...@hytechpro.com> on 2008/06/18 00:33:07 UTC
Product Upload
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?
RE: Product Upload
Posted by Rajeev Gupta <ra...@hytechpro.com>.
Raj/Ashish
That was useful.
-----Original Message-----
From: Ashish Vijaywargiya [mailto:vijaywargiya.ashish@gmail.com]
Sent: Wednesday, June 18, 2008 6:33 AM
To: user@ofbiz.apache.org
Subject: Re: Product Upload
No Problem Buddy :-).
--
Ashish
On Wed, Jun 18, 2008 at 5:47 AM, Raj Saini <ra...@gmail.com> wrote:
> Sorry, yes I mean CSV. Thanks Ashish.
>
> Raj
>
>
>
> Ashish Vijaywargiya wrote:
>
>> Rajeev,
>>
>>
>>
>>> Other option is use cvs.
>>>>
>>>>
>>>
>> I think it will be CSV. :-)
>> Here comes the link for Data File tool.
>>
http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools<http://docs.o
fbiz.org/display/%7Ejacopoc/OFBiz%27s+Data+File+Tools>
>>
>> If you would like to import your data from spreadsheet then following
JIRA
>> issue can be of help for you.
>> https://issues.apache.org/jira/browse/OFBIZ-1810
>>
>> I had put the code from above jira issue into the trunk in rev # 663627.
>> That code is only a sample code.You can customize that code according to
>> your need.
>>
>> --
>> Ashish
>>
>> On Wed, Jun 18, 2008 at 12:09 AM, Raj Saini <ra...@gmail.com> 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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>>
>
>
Re: Product Upload
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
No Problem Buddy :-).
--
Ashish
On Wed, Jun 18, 2008 at 5:47 AM, Raj Saini <ra...@gmail.com> wrote:
> Sorry, yes I mean CSV. Thanks Ashish.
>
> Raj
>
>
>
> Ashish Vijaywargiya wrote:
>
>> Rajeev,
>>
>>
>>
>>> Other option is use cvs.
>>>>
>>>>
>>>
>> I think it will be CSV. :-)
>> Here comes the link for Data File tool.
>> http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools<http://docs.ofbiz.org/display/%7Ejacopoc/OFBiz%27s+Data+File+Tools>
>>
>> If you would like to import your data from spreadsheet then following JIRA
>> issue can be of help for you.
>> https://issues.apache.org/jira/browse/OFBIZ-1810
>>
>> I had put the code from above jira issue into the trunk in rev # 663627.
>> That code is only a sample code.You can customize that code according to
>> your need.
>>
>> --
>> Ashish
>>
>> On Wed, Jun 18, 2008 at 12:09 AM, Raj Saini <ra...@gmail.com> 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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>>
>
>
Re: Product Upload
Posted by Raj Saini <ra...@gmail.com>.
Sorry, yes I mean CSV. Thanks Ashish.
Raj
Ashish Vijaywargiya wrote:
> Rajeev,
>
>
>>> Other option is use cvs.
>>>
>
> I think it will be CSV. :-)
> Here comes the link for Data File tool.
> http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools
>
> If you would like to import your data from spreadsheet then following JIRA
> issue can be of help for you.
> https://issues.apache.org/jira/browse/OFBIZ-1810
>
> I had put the code from above jira issue into the trunk in rev # 663627.
> That code is only a sample code.You can customize that code according to
> your need.
>
> --
> Ashish
>
> On Wed, Jun 18, 2008 at 12:09 AM, Raj Saini <ra...@gmail.com> 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
>>>
>>>
>>
>
>
Re: Product Upload
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
Rajeev,
>> Other option is use cvs.
I think it will be CSV. :-)
Here comes the link for Data File tool.
http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools
If you would like to import your data from spreadsheet then following JIRA
issue can be of help for you.
https://issues.apache.org/jira/browse/OFBIZ-1810
I had put the code from above jira issue into the trunk in rev # 663627.
That code is only a sample code.You can customize that code according to
your need.
--
Ashish
On Wed, Jun 18, 2008 at 12:09 AM, Raj Saini <ra...@gmail.com> 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
>>
>
>
Re: Product Upload
Posted by to...@gmail.com.
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 <ra...@gmail.com> 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
Re: Product Upload
Posted by Raj Saini <ra...@gmail.com>.
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
Re: Product Upload
Posted by BJ Freeman <bj...@free-man.net>.
you can look at the demoproducts.xml for how to import using xml and the
entities to use.
if you have flat file you can import using
http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools
if you have an excel file you can write a import class.
Rajeev Gupta sent the following on 6/17/2008 3:33 PM:
> 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?
>
>
>
>
>