Edit my Export CSV

Hi!

I'm really happy with my new webshop and I (almost) want the whole world to know!
That's why i'm signing up with some compare-websites and I need to upload my .csv file.

Here's the problem:
The CSV file is as-is, I can't edit any options (or at least can't find where to do so).

I try to upload to beslist.nl and here are the problems with the file:

- all the categories are exported too, I just want the products.
- image URL -> Only has XXXXXXX.jpg and not the complete URL to the image
- brand -> Only has the brand ID number, not the name of the brand
- price -> Price is multiplied x 100000 and excludes VAT, I need a column with price Incl VAT with normal notation (ex. 15,99 is displayed as 1321487 because of 21%BTW)

I have about 250 products and counting, but only filled in 30 of them right now, I edited the CSV manually to the standard they want and that works fine. But I was really hoping that hikashop could do this on its own..

I found how to add SKU and EAN to the article page, that was easier then I thought, just need to solve above problemd:(

Anyone have any tips on how to achieve what I want?

the URL for the shop is www.any-shop.nl by the way. Still in development, I'm planning to release it october 1st when the new VAT standards are in effect (19% -> 21%)

Hi,

I don't think there are any options to change the CSV. Guess you could do it by rewriting the code, but I wouldn't do that as way too much work. It would be easier to write a backend script that takes exactly what you want from the database, but of course you wouldn't be able to change and re-import.

Your other option (and something I have done to import products from a suppliers spreadsheet) is to write some VBA that reformats everything the way you want. For example, you would maintain a local lookup table in the spreadsheet to translate Brand ID to Brand Name - but then of course you'd have to keep the lookup up to date.

I'm only on 1.5.7 so maybe 1.6 introduced something new?

Tony

Hi Tony,

Thanx for your reply. My first version is 1.6 so i wouldnt know if there's anything new regarding this.

I thought of a work-around to get the good data, i create the new fields on add product and fill in the details of that product. Then I export to CSV and I have the data I need for all products.

ie:
I created new textboxes on product page invisible to customer: EAN, SKU, BRAND, PRICE, IMAGE-URL

Every product I have, I fill in the price in the regular spot, ánd in the new price box, same for BRAND.
I filled in in image box standard image-place, i only need to update the image name.
When I export, I only use the columns I need for beslist.nl and cut-paste them into a new csv document and upload that one.

Like i said, it's a workaround, but I wont have to edit all the prices in the CSV every time I change 1 price.

If anyone has a better (faster) solution I would be deeply gratefull.

Thanx again!

That's a good idea.

Just have to make sure all the duplicated (albeit different structures) remain in synch.

I think you have helped me there with some ideas I have been toying with.

Tony

Hehe, that's cool

Im just a newbie with hikashop, i'm glad I could help you ^^

Like I said, it would be better If we had an export function where we could select the rows we want to export, perhaps in a future version?

Hello,
On a earlier stage I started this topic www.hikashop.com/en/forum/4-how-to/62596...-from-front-end.html
concerning an export for Beslist.nl

As I see the website anypc is not available at the moment.
So my question is How did you create a CSV template?

and does the Hika team have found some time to help on this?

Like to hear from you

Hi Boudewijn,

The site opens october 1st. Because of the new TAX rate I decided to combine the new site with the new rate.

I created several new rows for my shop product called:

- EAN
- SKU
- PRODUCT_AFBEELDING
- PRODUCT_MERK
- PRODUCT_LEVERTIJD
- PRODUCT_LEVERKOSTEN
- PRODUCT_PRIJS

I fill in all these 7 items for each product. They are included in the CSV and at beslist.nl I check which one to use for every item. It's a bit of a workaround, but it works for now.
I have the luck that I don't have thousands of products, then it would be something else.

Hi,
thank you for your answer.
Do you mean that you created extra custom field?
And after filling this is you export these field?

Hoi Boudewijn, even in het nederlands dat is makkelijker.

Ik ga er vanuit dat je NL versie Hika hebt, ik heb bij de backend van hikashop het volgende gedaan:

Weergave -> Eigen velden -> Nieuw

Label: Prijs
Tabel: Product
Kolomnaam: PRODUCT_PRIJS
Veldtype: Tekst
Verplicht: Ja
Eigen foutmelding - leeg
Standaard waarde: - leeg

In de rechter kolom:
geactiveer: ja
frond-end: nee
backend formulier: ja
backend lijst: nee

Categorieën: Alle artikelen
Inclusief sub: ja

Nu heb je bij het maken of bewerken van een product, een extra veld onderin. Hier vul je (in dit geval) prijs inclusief BTW in.

Bij het exporteren van de complete artikelenlijst word er nu een extra tabel ge-exporteerd 'PRODUCT_PRIJS'. Bij beslist.nl kun je nu in het dropdown balkje aangeven dat Prijs(incl BTW) gelezen moet worden uit de tabel 'PRODUCT_PRIJS'.

Dit doe je voor alle (voor jou) relevante invoeropties van beslist.nl

Bij afbeelding-URL heb ik de 'Standaard waarde' ingevuld met: www.any-shop.nl/images/hika/etc/any00.jpg
Nu hoef ik bij ieder artikel alleen nog any00.jpg aan te vullen met de 3 cijfers van het artikel (bijv any00123.jpg). Dit omdat alle afbeeldingen dezelfde naam hebben als het artikelnummer.

Hoop dat het duidelijk is voor je.

Hallo,
Dank je voor je berichtje.
Het is me duidelijk hoe je het voor elkaar hebt gekregen.
Ik zal deze week proberen iets in elkaar te zetten.
Omdat wij een nogal uitgebreide collectie hebben zal ik één merk er uit halen.
Het blijft natuurlijk wel wat eindjes aan elkaar knopen.
Hoop dat Hika met een oplossing komt.

Hiervoor heb ik gewerkt met Virtuemart. Deze had een dergelijke functie standaard
Maar de laatste versie is een drama met het beheer van maten

Alvast bedankt,
Boudewijn

Yup, heb ook altijd met VM gewerkt, goed systeem maar gewoon te vol met kinderziektes in de nieuwste versie. Ergernissen alom.

Het is inderdaad wat behelpen maar ach, het werkt voorlopig. Het mooiste zou zijn als we konden aanvinken welke tabellen we willen exporteren en wat daar in moet komen. Maar ja