Posts by Mxkert

Mxkert · 2019-09-19T10:10:15+01:00

I fixed this issue by uploading all the images to the same bucket instead of giving all products their own bucket.

Mxkert · 2019-09-19T09:27:27+01:00

YES! It is working. Thanks a lot for the help Byron!

Mxkert · 2019-09-19T08:21:34+01:00

This is the result from the API call (only the first few products):

Code

{"data":[{"timestamp":"2019-02-03T14:46:45+01:00","productcode":"FO1","potsize":"21","height":"100","dutchname":"Areca \/ Dypsis Palm","linnaeusname":"Areca","numberperorder":"1","purchaseprice":"18.26","promotionaltext":"Groot en groen, maar niet t\u00e9 ruig. Een stijvolle plant.","description":"Goudpalm uit Madagaskar. Daar een bedreigde soort, maar onder andere op de Cara\u00efben zijn ze verwilderd en veel voorkomend. In de volle zon verkleuren de bladeren en de plant heeft gele bloemetjes: vandaar Goudpalm.\r\n\r\nDe Areca is niet makkelijk, maar wel populair in interieurs. Onder gunstige omstandigheden groeit hij tot aan het plafond. In de natuur kan hij 10 meter hoog worden.","specifications":"goudpalm; areca; pot 21 cm; hoogte 100 cm; groene plant; lichte plek in huis","caretips":"Zet de plant op een lichte plek, maar niet in de volle zon. De Goudpalm heeft ook een hekel aan tocht, en je moet er niet tegenaan lopen. Vermijd tenslotte radiatoren.\r\n\r\nGeef de palm in de zomer 2 \u00e0 3 keer per week lauwwarm water, 's winters 1 keer per week. Af en toe sproeien vindt ze fijn.\r\nDe plant groeit traag, geef haar hooguit in de groeiperiode 1 keer per maand voeding.","aboutgrower":"Fondieplant is \u00e9\u00e9n van de grootste Areca-palm kwekerijen in Europa.","branches":"","images":["https:\/\/www.floraathome.nl\/uploads\/products\/FO1\/FO1.jpg","https:\/\/www.floraathome.nl\/uploads\/products\/FO1\/FO1.3.jpg","https:\/\/www.floraathome.nl\/uploads\/products\/FO1\/FO1.2.jpg","https:\/\/www.floraathome.nl\/uploads\/products\/FO1\/FO1.4.jpg","https:\/\/www.floraathome.nl\/uploads\/products\/FO1\/FO1.5.jpg","https:\/\/www.floraathome.nl\/uploads\/products\/FO1\/FO1.6.jpg"],"grower":"Fondieplant","category":"Groene Plant"},
...

Mxkert · 2019-09-19T08:19:28+01:00

Yes, ofcourse.

PHP

<?php
$API = new PerchAPI(1.0, 'FloraAtHomeImporter');
$ProductImporter = $API->get('PerchShopProductImporter');
$AssetImporter = $API->get('AssetImporter');
require_once($_SERVER['DOCUMENT_ROOT'] . '/vendor/flora/vendor/autoload.php');
$apiInstance = new Swagger\Client\Api\ProductsApi(
// If you want use custom http client, pass your client which implements `GuzzleHttp\ClientInterface`.
// This is optional, `GuzzleHttp\Client` will be used as default.
new GuzzleHttp\Client()
);
$apitoken = "[MY_API_KEY]"; // string | Your unique API token
$type = "json"; // string | Choose \"json\" or \"xml\" as format for request and response data
try {
$result = $apiInstance->getAllProducts($apitoken, $type);
json_encode($result);
try {
ini_set('memory_limit','1024M');
set_time_limit(120);
foreach($result['data'] as $productData){
$result = $AssetImporter->add_item([
'type' => 'image',
'bucket' => $productData['dutchname'],
'path' => $productData['images'][0],
]);
$productData['assetID'] = (int) $result['id'];
$Template = $API->get('Template');
$Template->set('shop/products/product.html', 'shop');
$ProductImporter->set_template($Template);
// Run importer
$product = $ProductImporter->add_item([
'status' => true,
'stock_status' => '0',
'sku' => $productData['productcode'],
'title' => $productData['dutchname'],
'slug' => strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $productData['dutchname']))) . strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $productData['productcode']))),
'potmaat' => $productData['potsize'],
'hoogte' => $productData['height'],
'promotietekst' => $productData['promotionaltext'],
'beschrijving' => $productData['description'],
'specificaties' => $productData['specifications'],
'verzorgingstips' => $productData['caretips'],
'kweker' => $productData['grower'],
'over_de_kweker' => $productData['aboutgrower'],
'category' => 'planten/plant/',
'image0' => '',
'image0_assetID' => $productData['assetID'],
'price' => ['eur'=>str_replace(".", ",", $productData['purchaseprice'])],
'aantal_per_order' => $productData['numberperorder'],
]);
$Products = new PerchShop_Products();
if ($product) {
$newProduct = $Products->find($product['id']);
$newProduct->index();
}
}
header("Location: " . $_GET["returnURL"] . "?importeren=success");
}
catch (Exception $e) {
die('Error: '.$e->getMessage());
header("Location: " . $_GET["returnURL"] . "?importeren=failed");
}
header("Location: " . $_GET["returnURL"] . "?importeren=success");
} catch (Exception $e) {
echo 'Exception when calling ProductsApi->getAllProducts: ', $e->getMessage(), PHP_EOL;
header("Location: " . $_GET["returnURL"] . "?importeren=failed");
}

Display More

Maybe not the cleanest code.

Mxkert · Wednesday, 3:40 pm

I still get the same error, but I guess it could be due to the fact that I am working in the my_sample sample app, because I see this sample function in the apps runtime (which also uses the Template function):

Code

function my_sample_detail($thingID, $opts=array(), $return=false)
{
$default_opts = array(
'template' => 'thing.html',
'skip-template' => false,
);
if (is_array($opts)) {
$opts = array_merge($default_opts, $opts);
}else{
$opts = $default_opts;
}
$API = new PerchAPI(1.0, 'my_sample');
$Things = new MySample_Things($API);
$Thing = $Things->find($thingID, true);
if ($opts['skip-template']) {
return $Thing->to_array();
}
$Template = $API->get('Template');
$Template->set('sample/'.$opts['template'], 'sample');
$r = $Template->render($Thing);
if ($return) return $r;
echo $r;
return false;
}

Display More

Maybe I should clean up the app first...

Mxkert · Wednesday, 3:02 pm

And after deleting the AssetImport part of the code (so it is easier to just focus on the indexing of the products, without importing the assets), I get the following error:

Code

[Wed Sep 18 16:00:49.914965 2019] [fcgid:warn] [pid 14238:tid 140618135090944] [client 31.160.4.226:57320] mod_fcgid: stderr: PHP Fatal error: Uncaught Error: Call to a member function find_all_tags_and_repeaters() on null in /[ROOT]/[SITENAME]/perch/core/lib/PerchBase.class.php:185, referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 16:00:49.915093 2019] [fcgid:warn] [pid 14238:tid 140618135090944] [client 31.160.4.226:57320] mod_fcgid: stderr: Stack trace:, referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 16:00:49.915111 2019] [fcgid:warn] [pid 14238:tid 140618135090944] [client 31.160.4.226:57320] mod_fcgid: stderr: #0 /[ROOT]/[SITENAME]/perch/templates/pages/shop/importeren.php(76): PerchBase->index(), referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 16:00:49.915124 2019] [fcgid:warn] [pid 14238:tid 140618135090944] [client 31.160.4.226:57320] mod_fcgid: stderr: #1 /[ROOT]/[SITENAME]/perch/core/runway/start.php(43): include('/home/kndrxwbst...'), referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 16:00:49.915132 2019] [fcgid:warn] [pid 14238:tid 140618135090944] [client 31.160.4.226:57320] mod_fcgid: stderr: #2 /[ROOT]/[SITENAME]/perch/core/runway/start.php(47): perch_runway_dispatch_page(Object(PerchRoutedPage)), referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 16:00:49.915141 2019] [fcgid:warn] [pid 14238:tid 140618135090944] [client 31.160.4.226:57320] mod_fcgid: stderr: #3 {main}, referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 16:00:49.915148 2019] [fcgid:warn] [pid 14238:tid 140618135090944] [client 31.160.4.226:57320] mod_fcgid: stderr: thrown in /[ROOT]/[SITENAME]/perch/core/lib/PerchBase.class.php on line 185, referer: http://[DOMAIN]/perch/addons/apps/my_sample/

Mxkert · Wednesday, 2:58 pm

Ah ofcourse. I just edited that part but now it is giving me the following PHP errors:

Code

[Wed Sep 18 15:56:19.133775 2019] [fcgid:warn] [pid 14238:tid 140618059556608] [client 31.160.4.226:56902] mod_fcgid: stderr: PHP Warning: filesize(): stat failed for https://www.[DOMAIN].nl/uploads/products/FO1/FO1.jpg in /[ROOT]/[SITENAME]/perch/core/apps/assets/PerchAssets_Importer.class.php on line 47, referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 15:56:19.133855 2019] [fcgid:warn] [pid 14238:tid 140618059556608] [client 31.160.4.226:56902] mod_fcgid: stderr: PHP Fatal error: Uncaught Error: Call to a member function find_all_tags_and_repeaters() on null in /[ROOT]/[SITENAME]/perch/core/lib/PerchBase.class.php:185, referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 15:56:19.133866 2019] [fcgid:warn] [pid 14238:tid 140618059556608] [client 31.160.4.226:56902] mod_fcgid: stderr: Stack trace:, referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 15:56:19.133873 2019] [fcgid:warn] [pid 14238:tid 140618059556608] [client 31.160.4.226:56902] mod_fcgid: stderr: #0 /[ROOT]/[SITENAME]/perch/templates/pages/shop/importeren.php(76): PerchBase->index(), referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 15:56:19.133881 2019] [fcgid:warn] [pid 14238:tid 140618059556608] [client 31.160.4.226:56902] mod_fcgid: stderr: #1 /[ROOT]/[SITENAME]/perch/core/runway/start.php(43): include('/home/kndrxwbst...'), referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 15:56:19.133888 2019] [fcgid:warn] [pid 14238:tid 140618059556608] [client 31.160.4.226:56902] mod_fcgid: stderr: #2 /[ROOT]/[SITENAME]/perch/core/runway/start.php(47): perch_runway_dispatch_page(Object(PerchRoutedPage)), referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 15:56:19.133896 2019] [fcgid:warn] [pid 14238:tid 140618059556608] [client 31.160.4.226:56902] mod_fcgid: stderr: #3 {main}, referer: http://[DOMAIN]/perch/addons/apps/my_sample/
[Wed Sep 18 15:56:19.133902 2019] [fcgid:warn] [pid 14238:tid 140618059556608] [client 31.160.4.226:56902] mod_fcgid: stderr: thrown in /[ROOT]/[SITENAME]/perch/core/lib/PerchBase.class.php on line 185, referer: http://[DOMAIN]/perch/addons/apps/my_sample/

Mxkert · Wednesday, 2:37 pm

Hello Byron, thank you for the response. I tried it, but I get a PHP error:

Code

PHP Fatal error: Uncaught Error: Call to a member function index() on boolean in ......

While using the following import code:

Code

$result = $AssetImporter->add_item([
'type' => 'image',
'bucket' => $productData['dutchname'],
'path' => $productData['images'][0],
]);
$productData['assetID'] = (int) $result['id'];
$product = $ProductImporter->add_item([
'status' => true,
'stock_status' => '0',
'sku' => $productData['productcode'],
'title' => $productData['dutchname'],
'slug' => strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $productData['dutchname']))) . strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $productData['productcode']))),
'potmaat' => $productData['potsize'],
'hoogte' => $productData['height'],
'promotietekst' => $productData['promotionaltext'],
'beschrijving' => $productData['description'],
'specificaties' => $productData['specifications'],
'verzorgingstips' => $productData['caretips'],
'kweker' => $productData['grower'],
'over_de_kweker' => $productData['aboutgrower'],
'category' => 'planten/plant/',
'image0' => '',
'image0_assetID' => $productData['assetID'],
'price' => ['eur'=>str_replace(".", ",", $productData['purchaseprice'])],
'aantal_per_order' => $productData['numberperorder'],
]);
$Products = new PerchShop_Products();
if ($product) {
$newProduct = $Products->find($result['id']);
$newProduct->index();
}

Display More

Mxkert · Wednesday, 10:23 am

Hello,

I am using the product importer to import products, but they are not indexed after import. I have to save them manually to make them show up in the webshop.
A piece of my code:

Code

foreach($result['data'] as $productData){
$result = $AssetImporter->add_item([
'type' => 'image',
'bucket' => $productData['dutchname'],
'path' => $productData['images'][0],
]);
$productData['assetID'] = (int) $result['id'];
$ProductImporter->add_item([
'status' => true,
'stock_status' => '0',
'sku' => $productData['productcode'],
'title' => $productData['dutchname'],
'slug' => strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $productData['dutchname']))) . strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $productData['productcode']))),
'potmaat' => $productData['potsize'],
'hoogte' => $productData['height'],
'promotietekst' => $productData['promotionaltext'],
'beschrijving' => $productData['description'],
'specificaties' => $productData['specifications'],
'verzorgingstips' => $productData['caretips'],
'kweker' => $productData['grower'],
'over_de_kweker' => $productData['aboutgrower'],
'category' => 'planten/plant/',
'image0' => '',
'image0_assetID' => $productData['assetID'],
'price' => ['eur'=>str_replace(".", ",", $productData['purchaseprice'])],
'aantal_per_order' => $productData['numberperorder'],
]);
}

Display More

Mxkert · Tuesday, 11:52 am

Well a lot of assets do get imported correctly. I ran the importer 5 times, and all the images that are imported correct, show up 5 times (imported correctly) and the assets that are imported as blank/broken images, show up 5 times as broken images, so I think it has something to do with the size or something else related to the asset.

I am using the following code to import the assets, coming from an API:

PHP

<?php
$API = new PerchAPI(1.0, 'my_importer');
$Importer = $API->get('AssetImporter');
require_once($_SERVER['DOCUMENT_ROOT'] . '/vendor/flora/vendor/autoload.php');
$apiInstance = new Swagger\Client\Api\ProductsApi(
// If you want use custom http client, pass your client which implements `GuzzleHttp\ClientInterface`.
// This is optional, `GuzzleHttp\Client` will be used as default.
new GuzzleHttp\Client()
);
$apitoken = "[MY_API_KEY]"; // string | Your unique API token
$type = "json"; // string | Choose \"json\" or \"xml\" as format for request and response data
try {
$result = $apiInstance->getAllProducts($apitoken, $type);
json_encode($result);
try {
foreach($result['data'] as $productData) {
$aantal = count($productData['images']);
for ($x = 0; $x < $aantal; $x++) {
$result = $Importer->add_item([
'type' => 'image',
'bucket' => $productData['dutchname'],
'path' => $productData['images'][$x],
]);
}
}
header("Location: " . $_GET["returnURL"] . "?afbeeldingen-importeren=success");
} catch (Exception $e) {
header("Location: " . $_GET["returnURL"] . "?afbeeldingen-importeren=failed");
die('Error: '.$e->getMessage());
}
} catch (Exception $e) {
die('Error: '.$e->getMessage());
}

Display More

Mxkert · Sep 11th 2019

Oh sorry, I am using the Assets importer to import photos from products using an API.

Mxkert · Sep 8th 2019

Thank you, Hussein!

Mxkert · Sep 8th 2019

Quote from hus_hmd

One supported way of doing this is to write an app with an event listener to listen to the event Perch Shop fires when an order is complete. Hopefully the event returns all the data you need.

Thank you for this, I think I can use this very well.

Regarding the product SKU's, I found a solution by looking for the productID in the database and getting the SKU from that productID:

SQL

SELECT sku FROM perch3_shop_products WHERE productID = $productID

Mxkert · Sep 7th 2019

Hello,

When importing assets I am getting the following errors on some of the assets:

Code

[message] => filesize(): stat failed for https://www.[DOMAIN].nl/[IMAGE].jpg

Does this mean that the file size is too big? Approx 50% of the images get uploaded just fine, but the rest are broken images displayed in the assets app.

Mxkert · Sep 7th 2019

Byron, thank you for this example, it helped me a lot!

Yes I had a repeater field for the product images, because not all products have the same amount of images. But I could make individual image fields in my template, like image1, image2 etc. to work around it.

Mxkert · Sep 6th 2019

Well I am extending the PerchShop_Order.class.php to send the order through an external API. For that I am using the following code:

Code

// Order items
$OrderItems = new PerchShop_OrderItems($this->api);
$items = $OrderItems->get_by('orderID', $this->id());
$order_items = array();
if (PerchUtil::count($items)) {
foreach($items as $Item) {
$productcode = 'BA4';
$quantity = 2;
$order_items[] = array('productcode' => $productcode,'quantity' => (int) $quantity ,'text'=>'');
}
}
$result = $this->to_array();
$result['items'] = $order_items;
$order_items = json_encode($order_items);

Display More

Now I hardcoded the productcode (SKU) and the quantity and it is working fine. But now I have to get the productcode (SKU) and quantity for each product sold. Is there a way in which I could get those variables?

Mxkert · Sep 6th 2019

Hello,

Is it possible to import the images from a product with PerchShopProductImporter instead of the AssetImporter?

The JSON data is as follows (with multiple images in the array per product):

Code

{
"data": [
{
"images": [
"http://www.domain.nl/uploads/product/image.jpg"
],
}
]
}

Mxkert · Sep 6th 2019

Hello,

I am importing a lot of assets, but after some time I get a maximum execution time error. The error:

Code

mod_fcgid: stderr: PHP Fatal error: Maximum execution time of 30 seconds exceeded in MYDOMAIN/perch/core/lib/PerchImage.class.php on line 644

How can I increase this maximum execution time?

Thanks,

Mike

Mxkert · Sep 5th 2019

Hello,

I am trying to get the sku from a product, using the product id which I am getting from a shop order.

Could anyone tell me how I can get the sku from the following product:

Code

$Products = new PerchShop_Products($this->api);
$Product = $Products->find((int)1);

Mxkert · Sep 4th 2019

You could use something like this:

PHP

<?php
perch_blog_custom(array(
'count' => 1,
'template' => 'post_in_list.html',
'sort' => 'postDateTime',
'sort-order' => 'DESC',
));
?>

Posts by Mxkert

Importing assets

Perch Product Importer - Indexing products

Perch Product Importer - Indexing products

Perch Product Importer - Indexing products

Perch Product Importer - Indexing products

Perch Product Importer - Indexing products

Perch Product Importer - Indexing products

Perch Product Importer - Indexing products

Perch Product Importer - Indexing products

Importing assets

Importing assets

Perch API - Importing lots of assets, maximum execution time

Perch API - Get sku from product

Importing assets

Perch API - Importing products and images

Perch API - Get sku from product

Perch API - Importing products and images

Perch API - Importing lots of assets, maximum execution time

Perch API - Get sku from product

Latest blogpost on homepage