[Skip to main content](#vessel-content)

#   Export products-info, manufactures, variant

##

- **[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")**
- [![Micke&#95;skane's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile") Topic Author
- [ Offline](/forum/user/7228-micke-skane)

Less More

- Posts: 56
- Thank you received: 0
-
-

14 years 5 months ago [\#51661](#51661) by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")  *[Export products-info, manufactures, variant](/forum/2-general-talk-about-hikashop/51661-export-products-info-manufactures-variant#51661 "Hey,  Is it possible to export info about manufactures and variant-name and variant-images when you choose to export the products in Hikashop?  /Micke")* was created by *[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")*

Hey,

Is it possible to export info about manufactures and variant-name and variant-images when you choose to export the products in
Hikashop?

/Micke

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUxNjYxLWV4cG9ydC1wcm9kdWN0cy1pbmZvLW1hbnVmYWN0dXJlcy12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14281
-
-

14 years 5 months ago [\#51729](#51729) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Export products-info, manufactures, variant](/forum/2-general-talk-about-hikashop/51661-export-products-info-manufactures-variant#51729 "Hey,  Is it possible to export info about manufactures and variant-name and variant-images when you choose to export the products in Hikashop?  /Micke")*

Hi,

Yes, when you export products via the export button of the products listing, you get the variants and the manufacturer and the images names in the CSV.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUxNjYxLWV4cG9ydC1wcm9kdWN0cy1pbmZvLW1hbnVmYWN0dXJlcy12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")**
- [![Micke&#95;skane's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile") Topic Author
- [ Offline](/forum/user/7228-micke-skane)

Less More

- Posts: 56
- Thank you received: 0
-
-

14 years 5 months ago [\#51738](#51738) by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")  Replied by *[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")* on topic *[Re: Export products-info, manufactures, variant](/forum/2-general-talk-about-hikashop/51661-export-products-info-manufactures-variant#51738 "Hey,  Is it possible to export info about manufactures and variant-name and variant-images when you choose to export the products in Hikashop?  /Micke")*

I thought it should work like that but I can't find manufacturer, variant/variant-images?
Or shall the variant lists togehter with the other products, like under product_name?
Or shall the variant has it own column?

I can see the manufacturer_id but not the name of manufaturer.
Shall it be possible to export/see the name of manufacturers in the csv-file?

Now the CSV-file has the following columns:
product\_id
product\_parent\_id
product\_name
product\_description
product\_quantity
product\_code
product\_published
product\_hit
product\_created
product\_sale\_start
product\_sale\_end
product\_delay\_id
product\_tax\_id
product\_type
product\_vendor\_id
product\_manufacturer\_id
product\_url
product\_weight
product\_keywords
product\_weight\_unit
product\_modified
product\_meta\_description
product\_dimension\_unit
product\_width
product\_length
product\_height
product\_max\_per\_order
product\_access
product\_group\_after\_purchase
product\_min\_per\_order
product\_contact
product\_last\_seen\_date
product\_sales
product\_waitlist
product\_layout
parent\_category
categories\_image
categories
price\_value
price\_currency\_id
price\_min\_quantity price\_access
files
images
related
options
followed by several info(like productsnames) in the following columns first row(A-row in excel)...

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUxNjYxLWV4cG9ydC1wcm9kdWN0cy1pbmZvLW1hbnVmYWN0dXJlcy12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14281
-
-

14 years 5 months ago [\#51813](#51813) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Export products-info, manufactures, variant](/forum/2-general-talk-about-hikashop/51661-export-products-info-manufactures-variant#51813 "Hey,  Is it possible to export info about manufactures and variant-name and variant-images when you choose to export the products in Hikashop?  /Micke")*

In the product_manufacturer_id column, you get the id of the manufacturer.
Variants are added as extra lines: one line for the main product, one line for each of its variants.

If you want to have the name instead of the id of the manufacturer, you will have to edit the file "export" of the view "product" of your back end template via the menu Display&gt;Views. There change:

echo '"'.str_replace('"','""',$product-&gt;$column).'"'.$separator;

to:

if($column == 'product_manufacturer_id'){
$categoryClass = hikashop_get('class.category');
$category = $categoryClass-&gt;get($product-&gt;$column);
echo '"'.str_replace('"','""',$category-&gt;category_name).'"'.$separator;
}else{
echo '"'.str_replace('"','""',$product-&gt;$column).'"'.$separator;
}

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUxNjYxLWV4cG9ydC1wcm9kdWN0cy1pbmZvLW1hbnVmYWN0dXJlcy12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")**
- [![Micke&#95;skane's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile") Topic Author
- [ Offline](/forum/user/7228-micke-skane)

Less More

- Posts: 56
- Thank you received: 0
-
-

14 years 5 months ago -  14 years 5 months ago [\#51862](#51862) by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")  Replied by *[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")* on topic *[Re: Export products-info, manufactures, variant](/forum/2-general-talk-about-hikashop/51661-export-products-info-manufactures-variant#51862 "Hey,  Is it possible to export info about manufactures and variant-name and variant-images when you choose to export the products in Hikashop?  /Micke")*

Ok, I'll change the code so that the name are exported instead.
Why is this kind of changes something that shall be done manual instead of a "quick" choose/configuration in admin-part?

How about the productprice, is it possible the export annual price with discount?

Last edit: 14 years 5 months ago by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUxNjYxLWV4cG9ydC1wcm9kdWN0cy1pbmZvLW1hbnVmYWN0dXJlcy12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14281
-
-

14 years 5 months ago [\#51865](#51865) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Export products-info, manufactures, variant](/forum/2-general-talk-about-hikashop/51661-export-products-info-manufactures-variant#51865 "Hey,  Is it possible to export info about manufactures and variant-name and variant-images when you choose to export the products in Hikashop?  /Micke")*

Because everyone wants to do something different.
Some wants to remove columns, others wants different things in some of the columns, other formats, etc.
You can't have options for all the possible cases.
It's not possible to export the products price with discounts added.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUxNjYxLWV4cG9ydC1wcm9kdWN0cy1pbmZvLW1hbnVmYWN0dXJlcy12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")**
- [![Micke&#95;skane's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile") Topic Author
- [ Offline](/forum/user/7228-micke-skane)

Less More

- Posts: 56
- Thank you received: 0
-
-

14 years 5 months ago -  14 years 5 months ago [\#51881](#51881) by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")  Replied by *[Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile")* on topic *[Re: Export products-info, manufactures, variant](/forum/2-general-talk-about-hikashop/51661-export-products-info-manufactures-variant#51881 "Hey,  Is it possible to export info about manufactures and variant-name and variant-images when you choose to export the products in Hikashop?  /Micke")*

Is there a plugin or something if I want to export prices with discount too websites that list/compare products that customers search for from several vendors?

Is this something that can be programmed if theres not a plugin for export a pricefile with productprice with discount?

I've changed the code you suggested but it still export the ID in product_manufactorer_id and Not the name.
The code looks like this: Code:

foreach($products_columns as $column){ /*Här skrivs enbart tillverkar-ID ut*/ /*echo '"'.str_replace('"','""',$product-&gt;$column).'"'.$separator;*/ /*Här skrivs tillverkarnamnet ut*/ if($column == 'product_manufacturer_id'){ $categoryClass = hikashop_get('class.category'); $category = $categoryClass-&gt;get($product-&gt;$column); echo '"'.str_replace('"','""',$category-&gt;category_name).'"'.$separator; }else{ echo '"'.str_replace('"','""',$product-&gt;$column).'"'.$separator; } /* Slut på utskrift av tillverkarnamn*/ }

Have edit the code under my template and product/export.php!

Last edit: 14 years 5 months ago by [Micke\_skane](/forum/user/7228-micke-skane "View Micke&#95;skane's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUxNjYxLWV4cG9ydC1wcm9kdWN0cy1pbmZvLW1hbnVmYWN0dXJlcy12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14281
-
-

14 years 5 months ago [\#51938](#51938) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Export products-info, manufactures, variant](/forum/2-general-talk-about-hikashop/51661-export-products-info-manufactures-variant#51938 "Hey,  Is it possible to export info about manufactures and variant-name and variant-images when you choose to export the products in Hikashop?  /Micke")*

We do it for the google products plugin and for the RSS/Atom feeds.
You could potentially use these to generate exports but the format is XML not CSV.
The google products plugin is in the folder plugins/hikashop and the RSS/Atom feeds are generated with the components/com_hikashop/views/product/view.feed.php file.

That modification looks fine. Are you sure that you are editing the correct file ? If you add a
exit;
line of code, does that stops the processing ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUxNjYxLWV4cG9ydC1wcm9kdWN0cy1pbmZvLW1hbnVmYWN0dXJlcy12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.066 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
