google merchant center - export from aimeos

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
einmaku
Posts: 38
Joined: 26 Sep 2019, 13:29

google merchant center - export from aimeos

Post by einmaku » 23 Jan 2020, 16:13

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

User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: google merchant center - export from aimeos

Post by aimeos » 24 Jan 2020, 09:36

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 :-)
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

einmaku
Posts: 38
Joined: 26 Sep 2019, 13:29

Re: google merchant center - export from aimeos

Post by einmaku » 27 Jan 2020, 11:12

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.

User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: google merchant center - export from aimeos

Post by aimeos » 27 Jan 2020, 11:19

Ask the guys from the Aimeos company, they do custom implementations:
https://aimeos.com/aimeos-gmbh/contact
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

einmaku
Posts: 38
Joined: 26 Sep 2019, 13:29

Re: google merchant center - export from aimeos

Post by einmaku » 29 Jan 2020, 13:36

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

User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: google merchant center - export from aimeos

Post by aimeos » 29 Jan 2020, 18:46

Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

prosatya
Posts: 8
Joined: 05 Feb 2020, 09:41

Re: google merchant center - export from aimeos

Post by prosatya » 05 Feb 2020, 09:52

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.

User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: google merchant center - export from aimeos

Post by aimeos » 06 Feb 2020, 08:25

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
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

prosatya
Posts: 8
Joined: 05 Feb 2020, 09:41

Re: google merchant center - export from aimeos

Post by prosatya » 07 Feb 2020, 06:25

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

User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: google merchant center - export from aimeos

Post by aimeos » 08 Feb 2020, 08:33

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' );
}
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply