Bulk photo import and automatic product creation

[ondrei]

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

[aimeos]

If you need help, ask the Aimeos company to implement that for you:
https://aimeos.com/aimeos-gmbh/contact

[antoniosequeira66]

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.

[ondrei]

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.

[antoniosequeira66]

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.

[ondrei]

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:

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',
							],
						]
					]
				]
			]
		]
	]

test.csv:

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,∞

command:

Code: Select all

php artisan aimeos:jobs "product/import/csv"

[antoniosequeira66]

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.

[ondrei]

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.

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)

shop.php:

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',
							],
						]
					]

test.csv:

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

I'm trying all sorts of things and nothing helps .(

[aimeos]

Simplify your mapping and your file content to the basics only. You have some errors in there in the columns afterwards.

[ondrei]

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?