google merchant center - export from aimeos

[einmaku]

I want to export all product data to a excel or CSV list. The goal is to use this sheet for uploading it to Google merchant center (google shopping campaigns).
I do not find any export function
Thanks for help

[aimeos]

There's only a XML export for products (and all other data) available. You can implement an CSV export yourself like the CSV export for orders:
https://github.com/aimeos/ai-controller ... Export/Csv

We would love to get a pull request on Github with your implementation from you

[einmaku]

I am looking for an aimeos pro who can integrate the export functionality into our typo3. You have any recommandations to find? ...... or anybody here who likes to do this job for us?
Thanks for reply.

[aimeos]

Ask the guys from the Aimeos company, they do custom implementations:
https://aimeos.com/aimeos-gmbh/contact

[einmaku]

You wrote:
"There's only a XML export for products (and all other data) available. "
Where can I get the coding for XML export?

[aimeos]

You can find the code here:
https://github.com/aimeos/ai-controller ... andard.php

[prosatya]

Under TYpo3 Aimeos Where Avaiable ? XML export for products (and all other data) available

https://github.com/aimeos/ai-controller-jobs/
Is this code compatible for Typo 3 Extension aimeos with jobs.

If not how can i Extend aimeos and implement ai-controller-jobs under Typo 3 Extension aimeos.

Just give me some idea so i can start extend or integrate with Typo 3 Extension aimeos.

it will be great if any Documentation guide available.

[aimeos]

The ai-controller-jobs package is available in all integrations and also in the TYPO3 extension. It's available in ./typo3conf/ext/aimeos/Resource/Private/Extensions/.

Here's the documentation how you can implement a new job controller:
https://aimeos.org/docs/Developers/Cont ... controller

The existing job controllers are available here:
https://github.com/aimeos/ai-controller ... oller/Jobs

[prosatya]

Thank you for the response and provide the detail.

Now i'm Looking Aimeos-database. Architecture https://aimeos.org/fileadmin/download/A ... abase.svgz

Can you please provide detail relationship Between

• Product

• Price

• Media

• Attribute

How can i get All the detail by of the product . It would be grate if you provide SQL Query or idea of getting all the detail by SQL Query

[aimeos]

Do not use SQL to retrieve the data, use the product manager instead:
https://aimeos.org/docs/Developers#Managers_and_items

Code: Select all

$manager = \Aimeos\MShop::create( $context, 'product' );
$search = $manager->createSearch();
$items = $manager->searchItems( $search, ['attribute', 'media', 'price', 'text'] );
foreach( $items as $item ) {
	$attributes = $item->getRefItems( 'attribute' );
	$images = $item->getRefItems( 'media', 'default' );
	$prices = $item->getRefItems( 'price', 'default', 'default' );
	$name = $item->getRefItems( 'text', 'name' );
}