You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Richard Fleming <ri...@thebva.com> on 2007/02/15 04:45:42 UTC
WebTools Data Import problem.
Hi all,
I've imported a data xml file through the webtools interface and the import succeeded. I then generated keywords by clicking on the generate keywords button. I can pull each item up in product maintenance by keyword, but I can't pull them up in the ecommerce search until I click on the update button for the item in item maintenance. Then, magically, they start to appear on the website.... Any ideas? Do I need to run a product update routine on each imported item. Or, hopefully, is there a step that I'm missing?
Thanks
Rick
Re: WebTools Data Import problem.
Posted by Tim Ruppert <ti...@hotwaxmedia.com>.
Good find Richard.
--
Tim Ruppert
HotWax Media
http://www.hotwaxmedia.com
o:801.649.6594
f:801.649.6595
On Feb 14, 2007, at 10:03 PM, Richard Fleming wrote:
> Chris,
>
> I found the problem... "is_virtual" and "is_variant" must be set
> to something other than null. Apparently, when you click the
> "update" button, these are set to "N". As soon as I manually
> changed them in the database, the products started to pull up on
> the ecommerce site.
>
> Thanks
> Rick
>
> Richard Fleming <ri...@thebva.com> wrote:
> Chris, thanks for the reply
>
> I cleared the cache to no avail. I also shut the container down and
> restarted, still nothing. Do you know which entities are updated
> when the "update" button is clicked? I've ordered the docs but I'm
> too impatient to wait.
>
> Rick
>
> Chris Howe wrote:
> Have you tried clearing your cache?
> --- Richard Fleming wrote:
>
>> Hi all,
>>
>> I've imported a data xml file through the webtools interface and
>> the import succeeded. I then generated keywords by clicking on the
>> generate keywords button. I can pull each item up in product
>> maintenance by keyword, but I can't pull them up in the ecommerce
>> search until I click on the update button for the item in item
>> maintenance. Then, magically, they start to appear on the website....
>> Any ideas? Do I need to run a product update routine on each imported
>> item. Or, hopefully, is there a step that I'm missing?
>>
>> Thanks
>> Rick
>>
>
>
>
Re: WebTools Data Import problem.
Posted by Richard Fleming <ri...@thebva.com>.
Chris,
I found the problem... "is_virtual" and "is_variant" must be set to something other than null. Apparently, when you click the "update" button, these are set to "N". As soon as I manually changed them in the database, the products started to pull up on the ecommerce site.
Thanks
Rick
Richard Fleming <ri...@thebva.com> wrote:
Chris, thanks for the reply
I cleared the cache to no avail. I also shut the container down and restarted, still nothing. Do you know which entities are updated when the "update" button is clicked? I've ordered the docs but I'm too impatient to wait.
Rick
Chris Howe wrote:
Have you tried clearing your cache?
--- Richard Fleming wrote:
> Hi all,
>
> I've imported a data xml file through the webtools interface and
> the import succeeded. I then generated keywords by clicking on the
> generate keywords button. I can pull each item up in product
> maintenance by keyword, but I can't pull them up in the ecommerce
> search until I click on the update button for the item in item
> maintenance. Then, magically, they start to appear on the website....
> Any ideas? Do I need to run a product update routine on each imported
> item. Or, hopefully, is there a step that I'm missing?
>
> Thanks
> Rick
>
Re: WebTools Data Import problem.
Posted by Richard Fleming <ri...@thebva.com>.
Chris, thanks for the reply
I cleared the cache to no avail. I also shut the container down and restarted, still nothing. Do you know which entities are updated when the "update" button is clicked? I've ordered the docs but I'm too impatient to wait.
Rick
Chris Howe <cj...@yahoo.com> wrote:
Have you tried clearing your cache?
--- Richard Fleming wrote:
> Hi all,
>
> I've imported a data xml file through the webtools interface and
> the import succeeded. I then generated keywords by clicking on the
> generate keywords button. I can pull each item up in product
> maintenance by keyword, but I can't pull them up in the ecommerce
> search until I click on the update button for the item in item
> maintenance. Then, magically, they start to appear on the website....
> Any ideas? Do I need to run a product update routine on each imported
> item. Or, hopefully, is there a step that I'm missing?
>
> Thanks
> Rick
>
Re: WebTools Data Import problem.
Posted by Chris Howe <cj...@yahoo.com>.
Have you tried clearing your cache?
--- Richard Fleming <ri...@thebva.com> wrote:
> Hi all,
>
> I've imported a data xml file through the webtools interface and
> the import succeeded. I then generated keywords by clicking on the
> generate keywords button. I can pull each item up in product
> maintenance by keyword, but I can't pull them up in the ecommerce
> search until I click on the update button for the item in item
> maintenance. Then, magically, they start to appear on the website....
> Any ideas? Do I need to run a product update routine on each imported
> item. Or, hopefully, is there a step that I'm missing?
>
> Thanks
> Rick
>