Page 1 of 2

google merchant center - export from aimeos

Posted: 23 Jan 2020, 16:13
by 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

Re: google merchant center - export from aimeos

Posted: 24 Jan 2020, 09:36
by 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 :-)

Re: google merchant center - export from aimeos

Posted: 27 Jan 2020, 11:12
by 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.

Re: google merchant center - export from aimeos

Posted: 27 Jan 2020, 11:19
by aimeos
Ask the guys from the Aimeos company, they do custom implementations:
https://aimeos.com/aimeos-gmbh/contact

Re: google merchant center - export from aimeos

Posted: 29 Jan 2020, 13:36
by 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?

Re: google merchant center - export from aimeos

Posted: 29 Jan 2020, 18:46
by aimeos

Re: google merchant center - export from aimeos

Posted: 05 Feb 2020, 09:52
by 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.

Re: google merchant center - export from aimeos

Posted: 06 Feb 2020, 08:25
by 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

Re: google merchant center - export from aimeos

Posted: 07 Feb 2020, 06:25
by 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

Re: google merchant center - export from aimeos

Posted: 08 Feb 2020, 08:33
by 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' );
}