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
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' );
}