Bulk photo import and automatic product creation
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Bulk photo import and automatic product creation
Hello,
may I ask for some help? It's an urgent situation. I promised to launch a new website today featuring lot of photos from dance competitions, but I still can't get the bulk photo import to work .(
It should automatically create new products based on bulk import photo (the product name is automatically derived from the photo title, then sets the price to 50, tax to 0, currency in CZK - Czech koruna, infinite stock quantity, and all other required attributes for it to be an active item - all items same).
It keeps throwing an error, and even AI can't give me any advice.
I'm a frontend developer (and photographer) and I admit this is beyond my capabilities..
If I had to manually insert tens of thousands of photos and set all the required product properties, it would take me weeks.
Could someone please help me understand how to write this job controller? Clients are already calling and getting angry. I would be extremely grateful!
Aimeos Laravel
Aimeos version: Latest (2024.04)
PHP: 8.2
may I ask for some help? It's an urgent situation. I promised to launch a new website today featuring lot of photos from dance competitions, but I still can't get the bulk photo import to work .(
It should automatically create new products based on bulk import photo (the product name is automatically derived from the photo title, then sets the price to 50, tax to 0, currency in CZK - Czech koruna, infinite stock quantity, and all other required attributes for it to be an active item - all items same).
It keeps throwing an error, and even AI can't give me any advice.
I'm a frontend developer (and photographer) and I admit this is beyond my capabilities..
If I had to manually insert tens of thousands of photos and set all the required product properties, it would take me weeks.
Could someone please help me understand how to write this job controller? Clients are already calling and getting angry. I would be extremely grateful!
Aimeos Laravel
Aimeos version: Latest (2024.04)
PHP: 8.2
Re: Bulk photo import and automatic product creation
If you need help, ask the Aimeos company to implement that for you:
https://aimeos.com/aimeos-gmbh/contact
https://aimeos.com/aimeos-gmbh/contact
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
-
- Posts: 19
- Joined: 06 Dec 2022, 09:37
Re: Bulk photo import and automatic product creation
Hi,
first you need to create a csv file (easiest way) with your product information based on your images
then you need to add the import structure to your shop.php config file
then run the cron job
I did it today for 2000 products and all went well
contact me for further help if needed.
A.
first you need to create a csv file (easiest way) with your product information based on your images
then you need to add the import structure to your shop.php config file
then run the cron job
I did it today for 2000 products and all went well
contact me for further help if needed.
A.
Re: Bulk photo import and automatic product creation
Hi,
thanks a lot for your effort.
I considered importing via CSV, but I need to be able to import by just inserting photos in the future.
I tried countless variants of job controllers and uploading through admin, but I always got some errors, and all the guides on the internet are for older versions of Aimeos.
Even AI couldn't handle it (I tried four AI tools).
It shouldn't be that difficult, but I'm just missing something.
thanks a lot for your effort.
I considered importing via CSV, but I need to be able to import by just inserting photos in the future.
I tried countless variants of job controllers and uploading through admin, but I always got some errors, and all the guides on the internet are for older versions of Aimeos.
Even AI couldn't handle it (I tried four AI tools).
It shouldn't be that difficult, but I'm just missing something.
-
- Posts: 19
- Joined: 06 Dec 2022, 09:37
Re: Bulk photo import and automatic product creation
Sorry I don't understand what you mean.
you want to "import just by inserting photos" - Inserting photos where?
this can be done just by dropping the photo in a specific folder with a script to create the csv when a photo is detected and a job to import / create the product executed with a cron
Regards
A.
you want to "import just by inserting photos" - Inserting photos where?
this can be done just by dropping the photo in a specific folder with a script to create the csv when a photo is detected and a job to import / create the product executed with a cron
Regards
A.
Re: Bulk photo import and automatic product creation
Hello,
I'm trying to do it through import CSV, and it seems I am doing something wrong here as well .(
Could I ask for guidance on what I'm missing?
shop.php:
test.csv:
command:
I'm trying to do it through import CSV, and it seems I am doing something wrong here as well .(
Could I ask for guidance on what I'm missing?
shop.php:
Code: Select all
'controller' => [
'jobs' => [
'product' => [
'import' => [
'csv' => [
'location' => '/Users/ondrei/www/emotion/public/gallery/product/test.csv',
'skip-lines' => 1,
'mapping' => [
'item' => [
0 => 'product.code',
1 => 'product.type',
2 => 'product.label',
3 => 'product.scale',
4 => 'product.status',
],
'text' => [
5 => 'text.type',
6 => 'text.label',
7 => 'text.content',
8 => 'text.status',
],
'media' => [
9 => 'media.type',
10 => 'media.label',
11 => 'media.url',
12 => 'media.status',
],
'price' => [
13 => 'price.type',
14 => 'price.label',
15 => 'price.currencyid',
16 => 'price.value',
17 => 'price.costs',
18 => 'price.rebate',
19 => 'price.taxrate',
20 => 'price.status',
],
'attribute' => [
21 => 'attribute.status',
],
'catalog' => [
22 => 'catalog.code',
],
'stock' => [
23 => 'stock.stocklevel',
],
]
]
]
]
]
]
Code: Select all
product.code,product.type,product.label,product.scale,product.status,text.type,text.label,text.content,text.status,media.type,media.label,media.url,media.status,price.type,price.label,price.currencyid,price.value,price.costs,price.rebate,price.taxrate,price.status,attribute.status,catalog.code,stock.stocklevel
bob-00001,Article,bob-00001,1,1,bob-00001,bob-00001,bob-00001,0,standard,bob-00001,public/gallery/00001.jpg,1,default,CZK,CZK,50,0,0,0,1,0,home,∞
Code: Select all
php artisan aimeos:jobs "product/import/csv"
-
- Posts: 19
- Joined: 06 Dec 2022, 09:37
Re: Bulk photo import and automatic product creation
Hi, did you activate logs?
'log' => [
'manager' => [
'loglevel' => 7, // Enable debug logging into madmin_log table
],
],
do that, repeat process and check Log option in menu.
is your location correct?
location is a relative path
Laravel: ./storage/import/product/<sitecode>/
default <sitecode> is "default"
my settings
'jobs' => [
'product' => [
'import' => [
'csv' => [
'location' => 'product',
and my path is
.\storage\import\product\default
Hope this helps
A.
'log' => [
'manager' => [
'loglevel' => 7, // Enable debug logging into madmin_log table
],
],
do that, repeat process and check Log option in menu.
is your location correct?
location is a relative path
Laravel: ./storage/import/product/<sitecode>/
default <sitecode> is "default"
my settings
'jobs' => [
'product' => [
'import' => [
'csv' => [
'location' => 'product',
and my path is
.\storage\import\product\default
Hope this helps
A.
Re: Bulk photo import and automatic product creation
Thanks for the advice!
It's moved a bit, but I still can't see the products..?
The admin log says the products were imported, but they are nowhere to be seen.
shop.php:
test.csv:
I'm trying all sorts of things and nothing helps .(
It's moved a bit, but I still can't see the products..?
The admin log says the products were imported, but they are nowhere to be seen.
Code: Select all
2024-05-02 18:13:34 import/csv/product 6 488e0d0c1223862a88b5b2dbc3cb1d8d Finished product import from "product/default"
2024-05-02 18:13:34 import/csv/product 6 488e0d0c1223862a88b5b2dbc3cb1d8d Finished product import from "product/default/test.csv" (1/1)
Code: Select all
'csv' => [
'location' => 'product',
'skip-lines' => 1,
'mapping' => [
'item' => [
0 => 'product.code',
1 => 'product.type',
2 => 'product.label',
3 => 'product.scale',
4 => 'product.status',
],
'text' => [
5 => 'text.type',
6 => 'text.label',
7 => 'text.content',
8 => 'text.status',
],
'media' => [
9 => 'media.type',
10 => 'media.label',
11 => 'media.url',
12 => 'media.status',
],
'price' => [
13 => 'price.type',
14 => 'price.label',
15 => 'price.currencyid',
16 => 'price.value',
17 => 'price.costs',
18 => 'price.rebate',
19 => 'price.taxrate',
20 => 'price.status',
],
'attribute' => [
21 => 'attribute.status',
],
'catalog' => [
22 => 'catalog.code',
],
'stock' => [
23 => 'stock.stocklevel',
24 => 'stock.type',
],
]
]
Code: Select all
product.code,product.type,product.label,product.scale,product.status,text.type,text.label,text.content,text.status,media.type,media.label,media.url,media.status,price.type,price.label,price.currencyid,price.value,price.costs,price.rebate,price.taxrate,price.status,attribute.status,catalog.code,stock.stocklevel,stock.type
00001,default,bob00001,1,1,bob00001,bob00001,bob00001,0,default,bob00001,./public/media/bob00001.jpg,1,default,CZK,CZK,50,0,0,0,1,0,home,∞,default
Re: Bulk photo import and automatic product creation
Simplify your mapping and your file content to the basics only. You have some errors in there in the columns afterwards.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Bulk photo import and automatic product creation
I have not been able to read anywhere what the required product items are to make everything work immediately after import. Can I ask for help?
Which errors and how do I recognize them?
Which errors and how do I recognize them?