Announcing OXID eFire Extension Product Lister

marco.steinhaeuser · March 28, 2014, 12:29pm

Hi everybody,

OXID eFire Extension Product Lister is a freely available and scalable extension for OXID eShop for generating data feeds of your products and exporting them into many market places, price comparison portals and shopping platforms. Read on in this blog post to learn what it does exactly, how to use and to extend it and where to get it:

Please feel free to leave your comments and requests in this thread.

Regards

mediaworker · May 6, 2014, 6:24pm

Hi Marco,

i’ve installed this new eFire Extension, but in the shop-backend i have an error!

What i have done:

Installation on local server (both applications: oxid 4.8.4 and EPL)
Setup EPL: Only problem is the non-matching PHP-version, but the setup-process was successfull
Setup the EPL-module
When i tried to establish the first campaigne it says: “Es ist ein technischer Fehler aufgetreten, der in der Logdatei OEPL.log protokolliert wurde. Die Logdatei wird im Logverzeichnis des Shops gespeichert.”

But in the log there’s only an entry with: ‘_sMessage’ => ‘EPL_ERROR_PREPARING_REQUEST_DATA’

What does that mean?

OXID EShops von MediaClick!

Bissie · May 6, 2014, 10:22pm

Hi mediaworker,
the EPL shop module sends request data to the server application and get back a response. This error is thrown in server application side when the request data are extracted. On server side there is also a log file you get some more specific information. Log file location is set in setup process, default ist logs in install path.
You also can try to evaluate what is send to server application and received from it. Call to server is done in modules/oe/oepl/core/service/toSServer/oeplClient.php::callEplServer()

Hope that helps

Bissie

mediaworker · May 7, 2014, 10:39am

Hi Bissie,

THX for the quick reply.

I looked to the epl_diw.log on the EPL server side. There are some errors stating a FACADE_UNHANDLED_EXCEPTION_ERROR with a not found message. But: the searched file is not there, e.g. “gui\controller\front\setup.php”. There was never such a file?!

Another error is efire_“diw: CAMPAIGN_LIST_CONTROLLER_REQUEST_DECODE_ERROR 0=Corrupt request object:file=…/application/src/fromModule/controller/baseListController.php:line=182” but this file is encoded.

I will install the EPL again, perhaps there was a problem with the binary files…

Regards.

Bissie · May 7, 2014, 10:53am

IHi,

in this case the json encoded request object is corrupt. json_decode try to decode this string send in request and get a falso or not a array.
Try to log the sended request from module side, then you can see, what is sended. Maybe this will help to see, what is wrong. Best place is this callEplServer() method in eplClient class at module side. This is not encrypted and you can vardump the request object and the post parameters into a file.

Regards, Bissie

mediaworker · May 7, 2014, 12:04pm

Hi,

i did what you recommended and here is the output:


2014-05-07 11:50:11 $sPostParameters: 
Array
(
    [shopid] => oxbaseshop
    [token] => 841854d6818ba9e2199497b5090ea795
    [lang] => de
    [timestamp] => 1399456211
    [type] => campaignList
    [action] => getAllCampaignsList
    [request] => {"_sType":"campaignList","_blShowDeactivatedCampaigns":true,"_iPage":1,"_iItemsPerPage":10,"_sOrderByColumn":"title","_sOrderDirection":"ASC","_sAction":"getAllCampaignsList"}
)
2014-05-07 11:50:11 $oRequest:
oeplCampaignList Object
(
    [_sType:protected] => campaignList
    [_blShowDeactivatedCampaigns:protected] => 1
    [_iPage:protected] => 1
    [_iItemsPerPage:protected] => 10
    [_sOrderByColumn:protected] => title
    [_sOrderDirection:protected] => ASC
    [_sAction:protected] => getAllCampaignsList
)

It looks correct, right?

Bissie · May 7, 2014, 12:46pm

Hi,
this is ok. request data are decodable. Can you figure out, what comes in into server application? The calls destination is docroot/endpoint.php. Can you extract the POST values? Maybe there is a difference between sended and received data.

mediaworker · May 7, 2014, 4:00pm

Hi,

it seems to be the same, despite of backslashes in the request string:


[request] => {\"_sType\":\"campaignList\",\"_blShowDeactivatedCampaigns\":true,\"_iPage\":1,\"_iItemsPerPage\":10,\"_sOrderByColumn\":\"title\",\"_sOrderDirection\":\"ASC\",\"_sAction\":\"getAllCampaignsList\"}

Could that be a problem?

Regards.

Bissie · May 7, 2014, 4:32pm

Hi,
this is definitively the problem. This string with backslashes can not be decoded to array. So it fails. But I have no idea, where this backslashes come from.

Bissie

mediaworker · May 7, 2014, 4:55pm

Merde!

who can help?

Backslashes in the request-string has perhaps something todo with an escape. Has anybody an idea? Should we transfer this discussion into the german forum? Marco, what do you think?

@Bissie: nevertheless, thanks for your help!

Regards

marco.steinhaeuser · May 7, 2014, 5:16pm

Sure, no probs. Just open a new thread and refer to this post. We can also sum the results here.

Firefax · May 10, 2014, 2:12pm

Hi,
we installed the Product Lister on a local server. It looks very cool, powerful and maybe a little bit oversized.

But, at the moment, we have no idea how to install the Product Lister on our live system, which is a “Managed Server” . There are many steps in the installation process (or for the cronjobs) where you need full access to the server. On my managed webspace i dont have the full access to the files i shall change.

Maybe you can think about a installation guide for regular users a managed webspace.

cya

domino · May 10, 2014, 2:24pm

same problems. probably like the majority of users.

Firefax · June 20, 2014, 2:59pm

Hi,
i got somt time to have a look the the product-lister again.

at the moment its beta3. Any ideas when it will recieve stable status and/or will it be possible to update the product-lister (easily) (server/module/database) to a stable version?

Here my remarks to the [U]installation[/U]:

on my managed server, i do NOT have access to the webserver files i shall change in 3.1.3 and 3.1.4 (Handbuch Version 1.0.0 beta2). I have no var/www/epl/docroot oder /exports or a hosts file. I think i can ask my hoster to make the changes, but this should NOT be the common way. There should be a way to install the module without bothering the hoster.
What is the eplmodule_endpoint_url or endpoint.php good for (3.1.6)?
in 5.1.3 i can find the intruction for the crontab / cronjob, also here is only the info for full server access and not for a managed system.

cya

Firefax · June 20, 2014, 6:22pm

Now i had a look to the backend and new questions came:

I need a feed that will be updated every (two) hours. In the Backend, there is no way to tell the feed to be updated every hour, or on specific hours. The fastest update intervall is each day. Thats not fast enough!
I want some feed updated only once a night, but others every (2) hours, how can this be configured?
If the cronjob runs every 10 minutes (like in the example in the manuel), what is this good for? In the backend, i can only tell a campaign to run once a day?
Why do you need a separat database? And when will this database be updateted with the latest status (e.g. the item in stock status) ?
Do you have experiences with the performance? Is there a big advantage to the solution working directly in the shop database (like the CSV-Maker)?

Hope some can answer all my questions
Bissie?

All in all, i must say the product lister is very cool, just a little bit to much overhead.
cya

Firefax · June 23, 2014, 10:58am

Hi,

when I start the cronjob i get the following error message in the logfile:

127.0.0.1 efire_diw: EPL_MODUE_USAGE_WARNING msg=EPL_EXC_CURL_ERROR_MSG:shop=oxbaseshop:file=/var/www/epl/application/src/eplmodule/usage.php:line=73:time=1403508638

(I use the beta2 Files at the moment.)
Do you have any hint whats wrong?

cya

Bissie · June 23, 2014, 11:08am

Hi Firefax,
this error message looks like there is a problem when trying to connect the eShop for getting needed data. This service request the shop data (version, UTF-8 usage, db credentials …) for executing a campaign. There seems to be a problem using CURL.

Concerning your general questions about the EPL: I try to set up a wiki page describing all the EPL stuff, but this will take some time. But I’m on it.

Cheers, Bissie

Firefax · June 25, 2014, 5:18pm

Hi,
i surrender to install the product lister, because i need a working solution quickly.
For me the installation process is to difficult and i am infront of a lot of problems i have no idea how to solve them on my local server. There are also to many things i can not change directly on my managed system to try other things easly.

In my opinion, you should make it less complicate, so that a “regular” skilled User has a chance to install it. What are the (virtual) hosts good for? Why can’t the EPL Server be installed in a seperat path directly? (The system reqiurement bzip is not in the linked FAQ) …

cya

Bissie · June 27, 2014, 2:59pm

Hi all, I started to write down some general stuff about the Product Lister. You can find it here

sven_f1 · July 15, 2014, 9:56am

Any plans on releasing a non-BETA working version or to release a fully uncrypted CE version?
We installed the modul last week to have a closer look at it. After several problems the modul is running, but there are no files written to the export folder and it’s impossible to debug it