Questions tagged [export]

Denotes questions related to export in Magento.

1
vote
1answer
989 views

dataflow advanced profiles export with custom decimal separator

I need to change dot to comma on product price when I export using dataflown advanced profile. I tried this way: ... <action type="dataflow/convert_parser_csv" method="parse"> <var name=...
0
votes
1answer
88 views

Magento Product Export: Use price and image of configurable product for linked simple products

I am trying to find a way to export all my simple products with correct prices and images. For this I would also like to export all simple products linked to configurable ones. Since prices for these ...
0
votes
1answer
542 views

Export Categories with their ids to another installation

How can I export my categories and retain their ids? Magento dataflow exports categories by their ids instead of their names, but after using a script to copy categories to the new install, the ids ...
1
vote
3answers
3k views

eBay to magento integration

I have integrated magento products to eBay using M2E pro but now we have to integrated eBay product in to magento(reverse process). Is there any way to do this.
2
votes
1answer
574 views

Import problem: What is the importance of the table 'importexport_importdata', can i truncate it and what is it good for anyhow?

i have a problem with a clients Magento DB while trying to replicate it on my computer. Needless to say that i was not able to export the DB via the Magento Backend (using 1.6 Community version), ...
2
votes
1answer
3k views

Query to get product options Configurable in order

i need the query to get the all configurable options of a product in the order, In order, i wants to get the configurable product option like color, size by the query from that i cant used that into ...
1
vote
2answers
2k views

Howto export customer for excel?

I need to export customers into a excel format cvs would be ok. I tried System > Export/Import > Profiles but this does not work as the documentation explains: http://www.magentocommerce.com/...
4
votes
3answers
5k views

Customer CSV export fails with blank page

how's it going. I'm trying to export customers as a CSV file via System > Import/Export > Export, and I just get a blank page as a result. I select Entity Type of Customers and Export File Format of ...
3
votes
1answer
105 views

Ordering orders collection by newest

How can I sort orders by newest? Currently I'm filtering by complete and canceled status and I want to sort results by latest ordered date or by latest order ID. Now it show to me by the first ID lets ...
2
votes
2answers
2k views

XML orders export

Hi I'm using this code to get order in xml can any on help ho to get shipping method in xml file foreach($collection as $order) { if ($billingAddress = $order->getBillingAddress()){ ...
2
votes
0answers
2k views

Magento Configurable Product Export, Multiple Super Attribute Error Fix [closed]

There is a known issue affecting both the Magento Community and Enterprise Edition export system. The issue is with the core Import/Export functionality found in System > Import/Export > Export menu ...
3
votes
2answers
2k views

customer dataflow advanced profile export retrieve field updated_at in xml action with map name doesn't work

I am trying to export customers and want to export also the field updated_at which is in the table customer_adress_entity. As in the advanced profile dataflow export there is no choice to choose ...
0
votes
1answer
659 views

Export wishlist as CSV

A customer of us has a special need for his site.He wants each customer to be able to download his wishlist as CSV. Now my question is: I know how to do that on the back-end for my module using in ...
2
votes
1answer
639 views

Export media gallery images from magento 1.3

I`m trying to migrate a store from magento 1.3 to 1.8. When using "Export All Products" profile in dataflow, the output csv does not contain media_gallery columns and images. Is there a way to ...
0
votes
2answers
1k views

Source model not found error message when exporting customer info

Hello good people of Stack Exchange. Our small business has recently transferred our website to a new Magento hosting agency and we are experiencing an issue with the functionality for exporting ...
0
votes
1answer
2k views

How to export selected products to xml in admin product grid

i need to export selected product to xml form admin product grid. i have refer this to export selected product to csv. Can anyone help for this.
4
votes
1answer
2k views

how to give link to export button

In magento backend admin panel system->configuration->Main Website->Sales->Shipping Methods->Table Rates we have "export csv" which is downloading a file. like the same I have placed a export button ...
10
votes
4answers
35k views

Adding images with CSV import

I have been running into problem after problem with the CSV export/import functions. My currently problem is that I cannot seem to assign 'image', 'small_image', and 'thumbnail' attributes to any ...
1
vote
3answers
8k views

Dataflow advanced export filter by category

I want to filter the exported products by category, but what I have isn't working: <action type="catalog/convert_adapter_product" method="load"> <var name="store"><![CDATA[0]]>&...
2
votes
3answers
2k views

Programmatically increase package weight

I'm trying to write some code that will add a fixed amount of weight to orders, to account for packaging material. I've over-rideden Mage_Shipping_Model_Rate_Request with this code, in app/code/local/...
2
votes
1answer
3k views

How can I export fields which are not being displayed in admin grid?

I have a custom admin grid, which shows the feedback given by customers during checkout. I have 19 fields in the custom_table including entity_id, created_at and updated_at. This is my form view: ...
0
votes
2answers
807 views

How do I reliably export cc_type and cc_last4 with auth.net Direct Post?

I am using the Authorize Direct Post Payment Method with EE 1.13. I need to export credit card payment details including cc_type and cc_last4. In sales_flat_order_payment cc_type is null and cc_last4 ...
0
votes
1answer
5k views

Order CSV Export - what fields does it export?

I am exporting orders Sales > Orders to CSV. The problem is, I can't see which fields are actually exported. If anyone has any insight, I would much appreciate it.
1
vote
2answers
638 views

How to Sort a Large Number of an Attribute's “Manage Options (values of your attribute)”

I have a dropdown attribute with many options that need to be sorted. I am wondering how best to sort them automatically? If it can't be done automatically, is there a way to export the data from ...
4
votes
1answer
1k views

Importing product weights when multiple rows in CSV per product

Currently, practically every Magento import is yielding a frustrating experience in this particular project. Most product data is already in the system, configurables setup, each with all their ...
1
vote
2answers
3k views

Associate Products to Categories after Export CSV

Is there a way to associate products with categories? I've exported a csv with all the products, images etc (a complete export) then after the import (it wasn't painless) I've noticed 3 things 1) ...
1
vote
3answers
2k views

Moving Products from 1.4 to 1.7 - dilemma

I've to move a lot of products from an old Magento site (v. 1.4) to a new one (1.7) with fresh new theme with new modules it's also a multisite, infact there' already a lot of stuff I configured in ...
0
votes
1answer
1k views

ezmage migration tool for oscommerce to magento

I am trying to migrate data (categories, products, customers, and orders) from an osCommerce installation (ver 2.2rc2) to Magento (ver 1.7.0.2) using the migration tool offered at http://ezmage.com/...
4
votes
1answer
1k views

How to add CSV Import/Export Functionality

I have created custom gallery extension but I need to implement an import and export or gallery data in the CSV Format. I did too much research but couldn't find any useful link to find solution so ...
1
vote
1answer
4k views

Export Product CSV with Tier Price

I would like to create a CSV with product default data and also tier price. Is it possible to use DataFlow ? In alternative I would like to use a custom script with direct query to DB, can you help ...
12
votes
7answers
24k views

how to import gallery images with csv

Importing gallery images seems like such a fundamental function, but I cannot find any column in my csv exported file where I would do this. I created a single product with gallery images through ...
0
votes
1answer
745 views

Export products in 3rd party system that does not share the same server

I need to export products from Magento to 3rd party CMS, let's say Wordpress. My store will look like this: I don't need to integrate systems (neither sharing sessions, nor customers) There ...
8
votes
5answers
9k views

Adding a column to export but hiding from the grid?

I've created a custom report. The report has a significant number of fields in it which are required for when it's exported in CSV form. What I'm trying to figure out is if there's a way to omit the ...
27
votes
1answer
9k views

Conflicts in where clause with ambiguous column names

A bit of context for this. I want to extend the sales order export function (via the grid) to have more columns. I have created a module which adds a new grid for exporting and also a new collection ...
1
vote
3answers
3k views

How can I export products with cross or up-sells products?

In admin section (System->Import/Export) new Import/Export variant. If I use export all products and nothing have cross or up sells product, then export working fine. But if have any products cross ...