Jump to content

Recommended Posts

Module PrestaCenter XML Export Free

Prestashop Module PrestaCenter XML Export Free is used to create XML feeds and export products from a shop to price comparison services like Google Shopping, Kelkoo, Shopmania, etc. The default installation includes templates for the following services: Google Shopping, Heureka.cz, Zbozi.cz, Heureka.sk and Pricemania.sk.
The module allows easy define custom feeds template for any other services.

 

Module properties:
- support for customized XML feed export formats
- simple creation and modification of XML feeds templates
- support all installed currencies and languages
- possibility any number of export XML files

Restrictions:
- export file size is limited by available PHP memory
- free version does not support CRON

 

We are looking for a native English speaker to edit the English translation and translators in other languages. Are welcome contributors to create new templates for comparison shopping websites.

 

The module can be downloaded free of charge here (registration needed):

http://www.prestacs.cz/en/moduly/18-module-prestacenter-xml-export-free.html

Registered customers have access to the latest current version.

Edited by PrestaCS.cz (see edit history)
  • Like 6

Share this post


Link to post
Share on other sites
  • 2 weeks later...
  • Replies 387
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

Module PrestaCenter XML Export Free Prestashop Module PrestaCenter XML Export Free is used to create XML feeds and export products from a shop to price comparison services like Google Shopping, Kelk

Yes, this is correct - if you don't write the third value, then the out of stock products should not be exported. But it depends on general setting: in the BO select menu Preferences > Products, at

Hello,   How can we generate the xml feed?There is no option of Generate within the module itself once it is installed.Please kindly help us with thesame and mail us with documentation of the same m

  • 2 weeks later...

New version of module Module PrestaCenter XML Export Free - for Comparison shopping website is here:

 

Hi,

 

In version 1.5.6 gives me this error: ...modules/prestacenterxmlexportfree/controllers/admin/PcXmlFreeController.php on line 28

 

 

Regards

 

Francesc

Share this post


Link to post
Share on other sites
  • 2 weeks later...

I setup the module, it works great on ps 1.5.5

 

however I tried editing the template to also include supplier using line <g:mpn>{supplier_reference}</g:mpn>

 

but it is not present in feed at http://cloud-hookah.com/xml/google-en-eur.xml

 

Are you sure that you have in table given values ​​supplier_reference?

I tested now google feed modification with the {supplier_reference} and everything is OK (module version 1.0.0.9).

Share this post


Link to post
Share on other sites

Not sure what you mean by table, but I have under the product a value under both

 

Information tab > reference

and also

Supplier tab > Supplier reference

 

xml link is http://cloud-hookah.com/xml/google-en-eur.xml  Its just shows a blank tag for mpn

 

And for the xml template here is the code I'm using

 

<?xml version="1.0" encoding="utf-8" ?>
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:g="http://base.google.com/ns/1.0">
    <title>{shop_name}</title>
    <link rel="self" href="{shop_url}" />
    <updated>{update_feed}</updated>
    
        <entry ps_block="product">
        <title>{name}</title>
        <g:id>{id}</g:id>
        <link href="{url}" />
        <summary>{description_short}</summary>
        <updated>{update_item}</updated>
        <g:google_product_category></g:google_product_category>
        <g:product_type>{categories}</g:product_type>
        <g:image_link>{img_url}</g:image_link>
        <g:price>{price_vat_iso}</g:price>
        <g:condition>{condition: "new,used,refurbished"}</g:condition>
        <g:gtin>{ean}</g:gtin>
        <g:mpn>{supplier_reference}</g:mpn>
        <g:brand>{manufacturer}</g:brand>
        <g:availability>in stock</g:availability>
        </entry>
        
</feed>

  • Like 1

Share this post


Link to post
Share on other sites

Current Version Module PrestaCenter XML Export Free 1.0.0.10

 

New version 1.0.0.10 of the module has been developed and tested. This version is compatible with Prestashop 1.5.6.0.

Installation of this version will not overwrite already saved feeds templates.

 

Download module:

prestacenterxmlexportfree10010.zip

Edited by PrestaCS.cz (see edit history)

Share this post


Link to post
Share on other sites

After upgrading to 10010 I still wasn't able to figure out why {supplier_reference} wasn't showing, but changed it to the newly available {reference} and everything works great, so I just use that for now.

 

thanks

Share this post


Link to post
Share on other sites

I'm also looking into google trusted shops, which requires data feed for shipping and cancellation. It would be great if you could program in the variables so we can setup these feeds as well

Share this post


Link to post
Share on other sites

Module PrestaCenter XML Export Free 1.0.0.10

 

New version 1.0.0.10 of the module has been developed and tested. This version is compatible with Prestashop 1.5.6.0.

Installation of this version will not overwrite already saved feeds templates.

 

Download module:

 

 

Thank you!

 

this version works fine in 1.5.6, as I can make it work in multi-shop?

  • Like 1

Share this post


Link to post
Share on other sites

This is looking like the module I need for the comparison websites we use.
 
Just some questions / requests

  • Is it possible to cron the feeds?
  • Is it possible to only put products that are in stock in the feed? Products with stock level 0 are still in. I have ordering when not in stock activated.

What does this error mean?
XML template does not contain any element signed as a product.
I get it when I edit Google template, but left the product element as is.

Edited by MaartenPol (see edit history)

Share this post


Link to post
Share on other sites
  • 2 weeks later...

I also have another issue..

 

Can I send non-rewrite url to xml even when my shop uses rewrite urls? My comparison engine does not support rewrite urls.

 

Thanks

 

In the current version, this is impossible directly. I'll bookmark it to todo list.

 

But it is possible to change the file prestacenterxmlexportfree.php follows (add comments or remove if condition with the first part):

/*            if ($this->exportInfo['rewrite'] == 1) {
                $tmp['url'][$row['id_lang']] = $this->context->link->getProductLink($product,null,null,$row['ean13'],$row['id_lang'], null,0,true);
                $tmp['img_url'][$row['id_lang']] = !empty($row['id_image']) ? $this->context->link->getImageLink($row['link_rewrite'],$row['id_image'],$this->exportInfo['imgType']) : '';
            } else */{
                $tmp['url'][$row['id_lang']] = $this->context->link->getProductLink($product,null,null,$row['ean13'],$row['id_lang'], null,0,false);
                $tmp['img_url'][$row['id_lang']] = !empty($row['id_image']) ? $this->context->link->getImageLink('',$row['id_image'],$this->exportInfo['imgType']) : '';
            }

Share this post


Link to post
Share on other sites

I have already tried it but did not work.

seems that getProductLink function gets the url already rewriten.

 

 

 

In the current version, this is impossible directly. I'll bookmark it to todo list.

But it is possible to change the file prestacenterxmlexportfree.php follows (add comments or remove if condition with the first part):

/*            if ($this->exportInfo['rewrite'] == 1) {
                $tmp['url'][$row['id_lang']] = $this->context->link->getProductLink($product,null,null,$row['ean13'],$row['id_lang'], null,0,true);
                $tmp['img_url'][$row['id_lang']] = !empty($row['id_image']) ? $this->context->link->getImageLink($row['link_rewrite'],$row['id_image'],$this->exportInfo['imgType']) : '';
            } else */{
                $tmp['url'][$row['id_lang']] = $this->context->link->getProductLink($product,null,null,$row['ean13'],$row['id_lang'], null,0,false);
                $tmp['img_url'][$row['id_lang']] = !empty($row['id_image']) ? $this->context->link->getImageLink('',$row['id_image'],$this->exportInfo['imgType']) : '';
            }
Edited by joss54 (see edit history)

Share this post


Link to post
Share on other sites

Hi PrestaSc.cz thank very much for your module. I have installed it on Prestashop 1.5.6.0 and it worked very well but now after upgrade to prestashop 1.5.6.1 it dosen't work. Can you help me? Best regards.

  • Like 1

Share this post


Link to post
Share on other sites
  • 2 weeks later...

I've am trying to get in to this but i am not an coder so i have some difficulties with some subjects

 

1) I want that the availability to be exported like this:

        a) Stock =<0 - "Not Available"

        B) Stock >0 <5 - "Limited"

        c) Stock >5 "Available"

 

2) I have several groups of clients with different prices and i need to export one .XML for each with their specific prices. Prices do not have a rule of % or amount of discount, it is random.

 

3) I have a field that i have added to PS, can i export the value of that field also?

 

 

Is all this possible, either on free or pro version? if not, can be developed?

 

Thank you.

Share this post


Link to post
Share on other sites

I receive always this error:

 

This page contains the following errors:
error on line 2 at column 22: Encoding error
Below is a rendering of the page up to the first error.

 

 

My Template XML:

 

<?xml version="1.0" encoding="utf-8" ?>
<products>
<product ps_block="product">
<Referencia>{reference}</Referencia>
<Artigo>{name}</Artigo>
<Descricao>{description}</Descricao>
<DescricaoCurta>{description_short}</DescricaoCurta>
<PVPr com IVA>{pvpr}</PVPr com IVA>
<Categoria>{categories}</Categoria>
<Marca>{manufacturer}</Marca>
<price vat>{price_vat}</price vat>
<Imagem>{img_url}</Imagem>
<Disponibilidade>{days}</Disponibilidade>
<CodigoEAN>{ean}</CodigoEAN>
                <Part Number>{supplier_reference}</Part Number>
</product>
</products>

Share this post


Link to post
Share on other sites

I've am trying to get in to this but i am not an coder so i have some difficulties with some subjects

 

1) I want that the availability to be exported like this:

        a) Stock =<0 - "Not Available"

        B) Stock >0 <5 - "Limited"

        c) Stock >5 "Available"

 

2) I have several groups of clients with different prices and i need to export one .XML for each with their specific prices. Prices do not have a rule of % or amount of discount, it is random.

 

3) I have a field that i have added to PS, can i export the value of that field also?

 

 

Is all this possible, either on free or pro version? if not, can be developed?

 

Thank you.

 

We have 1) and 2) in todo list for PRO version.

  • Like 1

Share this post


Link to post
Share on other sites

I receive always this error:

 

This page contains the following errors:
error on line 2 at column 22: Encoding error
Below is a rendering of the page up to the first error.

 

My Template XML:

<?xml version="1.0" encoding="utf-8" ?>
<products>
<product ps_block="product">
<Referencia>{reference}</Referencia>
<Artigo>{name}</Artigo>
<Descricao>{description}</Descricao>
<DescricaoCurta>{description_short}</DescricaoCurta>
<PVPr com IVA>{pvpr}</PVPr com IVA>
<Categoria>{categories}</Categoria>
<Marca>{manufacturer}</Marca>
<price vat>{price_vat}</price vat>
<Imagem>{img_url}</Imagem>
<Disponibilidade>{days}</Disponibilidade>
<CodigoEAN>{ean}</CodigoEAN>
                <Part Number>{supplier_reference}</Part Number>
</product>
</products>

 

 

Your XML template is no valid XML file. In the tag names cannot be spaces.

Check your XML template here:

http://validator.w3.org/#validate_by_input

Edited by PrestaCS.cz (see edit history)

Share this post


Link to post
Share on other sites
  • 2 weeks later...

Is it possible to make this great module compatible with Multi Store? Or at least multi-store URL and imageURL compatible.

 

Thanks

 

Module for Multistore is already in Beta version. Full Multistore module version should be available later this week.

 

Differences between the versions

1. Free version:

- number of items is limited by PHP memory limit and max execution time

- unlimited languages

- unlimited currencies

- unlimited feeds

 

2. Pro version:

- allows export run time up to 20 times longer than the max execution time

- supports attributes and combinations

- CRON support

- available general XML feed which is suitable for wholesale export

- suitable for export More than 100,000 items

 

3. Multi version:

- features as the Pro version with unlimited Multistore shops

Edited by PrestaCS.cz (see edit history)

Share this post


Link to post
Share on other sites

I think multi store feature is a core function and should be part of the Free version. There are many advance features that you guys can included in the Pro version anyhow.

 

Cheers,

Alex

Share this post


Link to post
Share on other sites

when exporting xml it only excludes items that are inactive from shop. Can the xml exclude also items with zero availability? I need to show some products online and that are not in stock, but I don't want those products to be included in xml.

 

Can you help?

Thanks a lot..

Share this post


Link to post
Share on other sites

Here is a list of requested features:

 

- Choose image format for image URL

- Choose category and sub-categories

- Better attributes selection.

- Choose how to show inventory (0 or 1 or xx)

  • Like 1

Share this post


Link to post
Share on other sites

Thank you for this module.

I have some questions: Is there an way to export all image urls? And an export of attributes is this possible?

And I have one problem: some off my store products are in 3 categorie ( home, category and subcategory), but in export the categories fields for this products are blank.

Share this post


Link to post
Share on other sites

XML export does not work well with advanced stock management.

is searches quantity from ps_product table which is not right.

 

You should use 

$stock = StockAvailable::getQuantityAvailableByProduct($product['id_product'], $product['id_product_attribute']);

in order to exclude out of stock products.

 

If you fix this I will be glad to buy the Pro version.

Thanks

 

when exporting xml it only excludes items that are inactive from shop. Can the xml exclude also items with zero availability? I need to show some products online and that are not in stock, but I don't want those products to be included in xml.

 

Can you help?

Thanks a lot..

Edited by joss54 (see edit history)

Share this post


Link to post
Share on other sites

XML export does not work well with advanced stock management.

is searches quantity from ps_product table which is not right.

 

You should use 

$stock = StockAvailable::getQuantityAvailableByProduct($product['id_product'], $product['id_product_attribute']);

in order to exclude out of stock products.

 

If you fix this I will be glad to buy the Pro version.

Thanks

 

Bug will be fixed as soon as possible.

Share this post


Link to post
Share on other sites

Thank you for this module.

I have some questions: Is there an way to export all image urls? And an export of attributes is this possible?

And I have one problem: some off my store products are in 3 categorie ( home, category and subcategory), but in export the categories fields for this products are blank.

 

Attribute export is possible in Pro and Multi version. Export of all images will be available in the next release. English shop with all versions will be open this week.

 

Now you can export only the category that the product has defined as Default category.

Edited by PrestaCS.cz (see edit history)

Share this post


Link to post
Share on other sites

PrestaCenter XML Export Free 10.0.2.1

Current version introduces a system defined product availability, increased speed and improved compatibility with older versions of PrestaShop. In the base installation package is available new feed - General, which is intended for general export data, such as business partners.

Now is English as default module language.

 

The module can be downloaded directly here or by logging into the e-shop:

http://www.prestacs.cz/en

prestacenterxmlexportfree1021.zip

Edited by PrestaCS.cz (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

Using ">" as category separator give an error. how can this be fixes?

 

Also I would like to use some variable such as product ID inside a xml tag i.e. <product id={productid}>product info.. <product>

 

If you can add option to remove all items with  quantity 0 and have option to choose image size from other themes i will buy this module instantly. 

Share this post


Link to post
Share on other sites

You can use > instead of >

the problem with quantities is fixed in latest version which I tried.

 

For the rest you should wait for the developer..

 

Using ">" as category separator give an error. how can this be fixes?

 

Also I would like to use some variable such as product ID inside a xml tag i.e. <product id={productid}>product info.. <product>

 

If you can add option to remove all items with  quantity 0 and have option to choose image size from other themes i will buy this module instantly. 

Share this post


Link to post
Share on other sites

If you put <availability>{availability}</availability>

all products with 0 quantity will be removed and a number 0 will be shown in availability tag (0 days to be available = in stock)

 

If you put <availability>{availability: "in stock, on order, sold out"}</availability>

all products will be shown and the ones with 0 quantity will have "sold out" as text.

 

joss54 How do I remove all items from the xml list that have quantity 0??? I check the last version but do not know where this setting is.

Share this post


Link to post
Share on other sites

Using ">" as category separator give an error. how can this be fixes?

 

Also I would like to use some variable such as product ID inside a xml tag i.e. <product id={productid}>product info.. <product>

 

If you can add option to remove all items with  quantity 0 and have option to choose image size from other themes i will buy this module instantly. 

 

ID inside the XML tag is no problem. You have to insert the variable in quotes, like this:

<PRODUCT id="{id}">{name}</PRODUCT>

If you can exclude a product with zero quantities, is necessary set in BO "Allow ordering of out-of-stock products" to "No" and in {availability} set only first two values. In the next release, we add more options to availability.

 

In Pro and Multi version is possibility select image from all available variants.

Share this post


Link to post
Share on other sites

Can the module be update from BO, i.e get a update notice when a new version is available?

Also is there an option to show the sale price (If the item is on sale)?

 

Currently announce a new version only through the forum, twitter and e-mails. In the future, we prepare new version notification in the BO. When you buy a Pro or Multi version, you have still current version in the e-shop in your order.

 

Prices are exported with discounts according to the settings in the Specific prices.

Share this post


Link to post
Share on other sites

Does the pro version have attributes / feature selection?

 

Current version of Pro and Multi module supports export attributes and combinations. Export of features will be available in the next release in a few days (3-5).

Share this post


Link to post
Share on other sites
  • 2 weeks later...

 

What am I overlooking?

 

close.png Failed to create XML files (error description: Output XML files are not defined.). XML feeds have been restored to the previous state.

 

 

You have not defined any combination of feed for the installed language and currency combinations (English, Czech and EUR, CZK). You need to modify the original template feeds - change language and / or currency.

Share this post


Link to post
Share on other sites
  • 2 weeks later...

Hi, one question, I have to add in the module configuration element <g:identifier_exists> false </ g:identifier_exists>, but when I do not get what genre, and I need it because it requires me google merchant. Anyone know anything about it?

 

Thanks, regards

 

PD: My XML template

 

<?xml version="1.0" encoding="utf-8" ?>
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:g="http://base.google.com/ns/1.0">
    <title>{shop_name}</title>
    <link rel="self" href="{shop_url}" />
    <updated>{update_feed}</updated>
    
        <entry ps_block="product">
        <title>{name}</title>
        <g:id>{id}</g:id>
        <link href="{url}" />
        <summary>{description_short}</summary>
        <updated>{update_item}</updated>
        <g:product_type>{categories}</g:product_type>
        <g:image_link>{img_url}</g:image_link>
        <g:price>{price_vat_iso}</g:price>
        <g:condition>{condition: "new,used,refurbished"}</g:condition>
        <g:gtin>{ean}</g:gtin>
        <g:mpn>{supplier_reference}</g:mpn>
        <g:brand>{manufacturer}</g:brand>
        <g:availability>in stock</g:availability>
        <g:identifier_exists>false</g:identifier_exists>
        </entry>
        
</feed>

 

PD2: Solved, had to rebuild the xml after modify it

Edited by ekldj (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

 

Hi, one question, I have to add in the module configuration element <g:identifier_exists> false </ g:identifier_exists>, but when I do not get what genre, and I need it because it requires me google merchant. Anyone know anything about it?

 

Thanks, regards

 

 In the following versions of the module will add the possibility to define a value if an arbitrary variable is empty.

Share this post


Link to post
Share on other sites
  • 2 weeks later...

I've am trying to get in to this but i am not an coder so i have some difficulties with some subjects

 

1) I want that the availability to be exported like this:

        a) Stock =<0 - "Not Available"

        B) Stock >0 <5 - "Limited"

        c) Stock >5 "Available"

 

2) I have several groups of clients with different prices and i need to export one .XML for each with their specific prices. Prices do not have a rule of % or amount of discount, it is random.

 

3) I have a field that i have added to PS, can i export the value of that field also?

 

 

Is all this possible, either on free or pro version? if not, can be developed?

 

Thank you.

 

 

We have 1) and 2) in todo list for PRO version.

 

 

Any news on this? i tried to contact by e-mail with no asnwer.

 

I am trying to explore the module free better before buying the pro and  will need some support, i get errors on export but i believe that is an issue i will not have in pro version.

 

Should i get all support from the forum?

Share this post


Link to post
Share on other sites

Any news on this? i tried to contact by e-mail with no asnwer.

 

I am trying to explore the module free better before buying the pro and  will need some support, i get errors on export but i believe that is an issue i will not have in pro version.

 

Should i get all support from the forum?

 

The new version of the module Free, Pro and Multi will be available next week. Because we have added many new features into this version, your requirements (1 and 2) will be added to the next version within a month.

 

Can You describe problems of export in detail?

Share this post


Link to post
Share on other sites

The new version of the module Free, Pro and Multi will be available next week. Because we have added many new features into this version, your requirements (1 and 2) will be added to the next version within a month.

 

Can You describe problems of export in detail?

 

Hi. Thanks for the quick answer

 

The main issues that i was able to see up until now is:

 

1) Parse errors: I need this to export to a XML to give has a product list to clients, and most of them will open it in excel. I am not able to open the file without editing it and deleting the characters that do this.

 

2) In portuguese there are some characters like "Ç" "Ã" "Â" and others that export with errors. If i understood correctly the pro version allows this special characters, right?

 

3) I have products like Tablets, TV and others and we are talking about, for example, a 42" inch screen, the " character or even '' transforms in a set of strange characters

 

Besides this, i wonder:

 

A) i noticed that i could export some fields that are not in the help, like "supplier_reference" but not others... wondering if i could put others to export. I have some custom fields and one speccially would be important to export.

 

B) Can i export only the products that are with the status active in the store?

 

C) Can I put categories in collumns instead of in the same collumn separated by a character like "|" or ">" ?

Share this post


Link to post
Share on other sites

Hi. Thanks for the quick answer

 

The main issues that i was able to see up until now is:

 

1) Parse errors: I need this to export to a XML to give has a product list to clients, and most of them will open it in excel. I am not able to open the file without editing it and deleting the characters that do this.

 

2) In portuguese there are some characters like "Ç" "Ã" "Â" and others that export with errors. If i understood correctly the pro version allows this special characters, right?

 

3) I have products like Tablets, TV and others and we are talking about, for example, a 42" inch screen, the " character or even '' transforms in a set of strange characters

 

Besides this, i wonder:

 

A) i noticed that i could export some fields that are not in the help, like "supplier_reference" but not others... wondering if i could put others to export. I have some custom fields and one speccially would be important to export.

 

B) Can i export only the products that are with the status active in the store?

 

C) Can I put categories in collumns instead of in the same collumn separated by a character like "|" or ">" ?

 

1. Send me your XML file with parsing errors via e-mail.

 

2.   "Ç" "Ã" "Â" characters are enabled in all versions of the module. They are regular UTF-8 characters. Do You use UTF-8 coding in the XML file header? I don't understand exactly where you are having problems with these characters.

 

3. In Pro version You can use CDATA modifier for export special characters.

 

A. In current versions you cannot use user defined variables. If you want to use this features for your private variables, we can do for you specific modification.

 

B. Not now - we prepare advanced availability setting in next version.

 

C. I add this in to-do list.

 

 

Share this post


Link to post
Share on other sites

1. Send me your XML file with parsing errors via e-mail.

 

2.   "Ç" "Ã" "Â" characters are enabled in all versions of the module. They are regular UTF-8 characters. Do You use UTF-8 coding in the XML file header? I don't understand exactly where you are having problems with these characters.

 

3. In Pro version You can use CDATA modifier for export special characters.

 

A. In current versions you cannot use user defined variables. If you want to use this features for your private variables, we can do for you specific modification.

 

B. Not now - we prepare advanced availability setting in next version.

 

C. I add this in to-do list.

 

 

 

1. It's a bit big, you can get it here (After reading your e-mail a looking again at the file i think this errors are related with Special characters, can you confirm?

 

2. Solved with UTF-8 (Sorry, i am not an expert on this)

 

3. Ok, thanks.

 

 

A. We can talk about this. I just need one field that basically is the "Recomended street retail price" that i had to add by hand. Or if i can put this info in another field that i am not using, or maybe by creating a specific price in the database, maybe it's easy.

 

B. Ok, not urgent:

 

C. Great, thanks.

 

 

 

You will release info about the new versions when ready here at the forum right? As long has specific prices are exporting i can buy it. 

 

Thanks

Share this post


Link to post
Share on other sites

1. It's a bit big, you can get it here (After reading your e-mail a looking again at the file i think this errors are related with Special characters, can you confirm?

 

For correct this problem You can use CDATA section like this:

<PRODUCT><![CDATA[{name}]]></PRODUCT>

Share this post


Link to post
Share on other sites

I have XML Export Pro and since today I installed another module which Dispatcher.php conflicts with.

SEO search landing pages

http://www.prestashop.com/forums/topic/268490-free-seo-module/

 

 

I really need the other module, can you help so Presta will work with both?

 

Thanks

 

1. If you have installed one from these modules, remove file override/classes/Dispatcher.php

2. Install second module

3. Replace file override/classes/Dispatcher.php with this code (is valid for both modules):

<?php
class Dispatcher extends DispatcherCore
{
    public $use_routes = false;

    public function loadRoutes($id_shop = NULL)
        {
        parent::loadRoutes();
        $orderby = (isset($_REQUEST['orderby']) && $_REQUEST['orderby']) ? $_REQUEST['orderby'] : 'position' ;
        $orderway= (isset($_REQUEST['orderway']) && $_REQUEST['orderway']) ? $_REQUEST['orderway'] : 'asc' ;
        $results = Db::getInstance()->executeS('
                        SELECT s.id_searchterm, s.term,s.url,s.title,s.description
                        FROM '._DB_PREFIX_.'searchterm s ');
        foreach($results as $result)
            foreach (Language::getLanguages() as $lang)
                $this->addRoute('search_'.$result['id_searchterm'],$result['url'],'search',$lang['id_lang'],array(), array('search_query' =>$result['term'], 'orderby' => $orderby, 'orderway' => $orderway));
    }
}
  • Like 1

Share this post


Link to post
Share on other sites

This worked great! Thank you.

Cron in Pro version is super helpful  :)

 

 

1. If you have installed one from these modules, remove file override/classes/Dispatcher.php

2. Install second module

3. Replace file override/classes/Dispatcher.php with this code (is valid for both modules):

<?php
class Dispatcher extends DispatcherCore
{
    public $use_routes = false;

    public function loadRoutes($id_shop = NULL)
        {
        parent::loadRoutes();
        $orderby = (isset($_REQUEST['orderby']) && $_REQUEST['orderby']) ? $_REQUEST['orderby'] : 'position' ;
        $orderway= (isset($_REQUEST['orderway']) && $_REQUEST['orderway']) ? $_REQUEST['orderway'] : 'asc' ;
        $results = Db::getInstance()->executeS('
                        SELECT s.id_searchterm, s.term,s.url,s.title,s.description
                        FROM '._DB_PREFIX_.'searchterm s ');
        foreach($results as $result)
            foreach (Language::getLanguages() as $lang)
                $this->addRoute('search_'.$result['id_searchterm'],$result['url'],'search',$lang['id_lang'],array(), array('search_query' =>$result['term'], 'orderby' => $orderby, 'orderway' => $orderway));
    }
}

Share this post


Link to post
Share on other sites

I've downloaded the latest version from your site, unfortunately the xml creating is empty. Language is German. Generation of XML is successful, but there are no data in it. Any advise what is going wrong ?

 

Tried also the version 10.0.8, same problem. I'm using PS 1.5.3.1.

 

I checked from where the problem is comming: No support for German characters on description_short.

Edited by selectshop.at (see edit history)

Share this post


Link to post
Share on other sites

I've downloaded the latest version from your site, unfortunately the xml creating is empty. Language is German. Generation of XML is successful, but there are no data in it. Any advise what is going wrong ?

 

Tried also the version 10.0.8, same problem. I'm using PS 1.5.3.1.

 

The problem may be availability of products. See {availability} in module help.

If you cannot solve this problem, send the XML template and printscreen of the feed settings via e-mail or PM.

Share this post


Link to post
Share on other sites

2.238 errors on availability, 2.448 errors on description. I deleted the line description_short on feed because I don't have any short description.

 

For the line description (default, nothing changed or added) the feed is giving (no description).

 

For my shop you can order also products not in stock, so this line should be fine ? <g:availability>{availability: "in stock, on order, sold out"}</g:availability>

Share this post


Link to post
Share on other sites

2.238 errors on availability, 2.448 errors on description. I deleted the line description_short on feed because I don't have any short description.

 

For the line description (default, nothing changed or added) the feed is giving (no description).

 

For my shop you can order also products not in stock, so this line should be fine ? <g:availability>{availability: "in stock, on order, sold out"}</g:availability>

 

In previous versions the XML template was an error in the definition of availability to Google Merchant. Correct availability for Google Merchant:

<g:availability>{availability: "in stock, available for order, out of stock"}</g:availability>

If you have special characters in some text fields, you must use CDATA section like this:

<summary><![CDATA[{description}]]></summary>

In next post is link to new version of module...

 

Share this post


Link to post
Share on other sites

New version of module PrestaCenter XML Export Free 1.1.0.1

- new date and time fields

- in the price can be used comma (or another symbol) as a decimal separator instead of dot

- corrected XML file for Google Merchant

 

In the Pro and Multi version of the module is many new functions, including feature export.
New versions of Pro and Multi release tomorrow ...

prestacenterxmlexportfree1101.zip

Edited by PrestaCS.cz (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

In previous versions the XML template was an error in the definition of availability to Google Merchant. Correct availability for Google Merchant:

<g:availability>{availability: "in stock, available for order, out of stock"}</g:availability>

If you have special characters in some text fields, you must use CDATA section like this:

<summary><![CDATA[{description}]]></summary>

In next post is link to new version of module...

Thank you I will try, although availability is already fixed.

 

What's about the category feeds ? Also this line delivers an error, because you cannot map your categories to the categories of Google merchant. Or is it possible with Pro version ?

Edited by selectshop.at (see edit history)

Share this post


Link to post
Share on other sites

If you have special characters in some text fields, you must use CDATA section like this:

<summary><![CDATA[{description}]]></summary>

In next post is link to new version of module...

This line does not solve the problem. When I delete the line completely (so no description at all), XML works.

Edited by selectshop.at (see edit history)

Share this post


Link to post
Share on other sites

New version of module PrestaCenter XML Export Free 1.1.0.1

- new date and time fields

- in the price can be used comma (or another symbol) as a decimal separator instead of dot

- corrected XML file for Google Merchant

 

In the Pro and Multi version of the module is many new functions, including feature export.

New versions of Pro and Multi release tomorrow ...

 

Hi

 

Not being able to install on 1.5.6.2, any known issue?

 

Says the module is transfered, but then it does not appear on the modules list to install

Share this post


Link to post
Share on other sites