export product to yahoo shopping help need

StartPrev 1 2 NextEnd
15.03.2013 05:08
#1
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
export product to yahoo shopping help need

dear admin
hi
first i want to thank you for amazon export addon
i try to send this topic as new one maybe another one are interested in this matter
the same as amazon i want to submit all of my product to yahoo shopping via csv ,but the different is that i have product in my yahoo shopping store but not all and i want to put all of my product on that
in my knowledge amazon did not have category in its csv file but yahoo shopping have and here by i send you the csv file sample related to my product in yahoo shopping that i download today from their site,
and with that i send the yahoo shopping information on csv ( japanese but can be transalted by google and my shop link in yahoo shopping )
i hope you can fine a solution for getting this job
i send csv sample file by zip and another link

yahoo shopping csv related page ( can be translate by google)
http://storedoc.ec.yahoo.co.jp/s/shopping/manual/itemmgr/d/051.html

my store in yahoo shopping
http://store.shopping.yahoo.co.jp/ariyacarpet/index.html

if need any other information ,please let me know
with thanks
best regards
ariyagallery
yahoo.csv_data.zip


Joomla: 2.5.7
JoomShopping: 3.11.0
PHP: 5.2.17
Website Url: http://ariya-carpet.co.jp/

Last change: 15.03.2013 05:14
 
15.03.2013 11:43
#2
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

Hallo!
I'm doing this addon

I need connection with the fields of joomshopping?
Thanks.

path - Category
name - Title
code - Product code (ean, jan) ?
Sub-code -?
original-price - Old price
price - Price
sale-price -?
options - ?
headline - Description
caption -?
abstract -?
explanation -?
additional1
additional2
additional3
relevant-links -?
ship-weight
taxable - Tax
release-date
temporary-point-term
point-code
meta-key - META keywords
meta-desc - META description
template -?
sale-period-start
sale-period-end
sale-limit
sp-code
brand-code
person-code
yahoo-product-code
product-code
jan
isbn
delivery -?
astk-code -?
condition -?
taojapan -?
product-category -?
spec1
spec2
spec3
spec4
spec5
display =1 ?

 
15.03.2013 15:44
#3
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

image link?
Manufacturer name ?

 
16.03.2013 09:23
#4
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
Aw: export product to yahoo shopping help need

dear vova
thanks for you reply
i get some information about yahoo shopping about the csv file but not all of my anwser
so here by i try to explain for you
first i found that 6 of these csv part are must and needto be there and remaining are option
the must part are: path,name,code,price,saleprice,product-category
for image link,,,in yahoo shopping image must be upload via image uploader and after uploading csv file try to relate the same image number with the same product number ,,so image link is no need in csv file
manufacturer name must be an option and i did not use that because of my product speciality and i can not see that in my csv sample file so i belive without that the csv must work properly
one most difficult problem in connection fields of joomshopping is that in yahoo shopping the same field have character limit ,,for example,,Headline which we can say it must be explanation ,,in yahoo have 30 character limit ,while i have used more character in my site ,,so if we connect headline to explanation ,probably it will get error because of character limits,,,
here are my suggestion for joomshopping fields and i think for not connection filed it is better to put the same as yahoo shopping and for some part i have to put data by hand to fulfill the yahoo limitation
MUST filed:
path : categories
name: title
code: product code
original price : old price
price: price
product-category : not have joomshopping some 4 digit prepare by yahoo which must fill by hand
option filed
option : product characteristric ( not sure)
headline:not in joomshjopping
caption: short description
abstract: not in joomshopping
explanation: description
additional:2:3 : feree space for product explanation : not in joomshopping
relevant link: related product
shipweight :weight
taxable: some figure between 1 and 0 not in joomshopping and in yahoo all are 1
release date: date
temporary-point term : not in joomshopping
point code : yahoo shopping point ( not in joomshopping)
meta key: meta kewords
meta desc: meta description
template: not in joomshopping special template used by yahoo ( fill by hand )
sale period start: not in joomshopping
sale period end ,,
sale-limit ,,
sp-code ,,
brand-code ,,
person-code
dera vova this is all could understand by comparing yahoo csv and joomshopping
i hope you can fine some image to get done this job
if you need more explanation in detail let me know then i will ask from yahoo directly
even though i am not good in this filed but i think to have all aspect of yahoo shopping in csv must
give me the opportunity to fill some data by hand if it is in need actually
with thanks
best regards
ariya gallery

 
16.03.2013 10:39
#5
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
Aw: export product to yahoo shopping help need

dear vova
sorry i lost for remaining parts of scv
yahoo product code: just belong to yahoo and not is joomshopping (a 10-12 digit number)
jan: JAN
isbn: ISBN
delivery : transfer charge ( 0,1,2,3)
astk-code : delivery time ( today or tomorrow ) fast delivery (not in joomshop)
condition : product new or old (not in joomshopping )
taojapan : no explanation from yahoo japan probabley no need
product category :mentioned above some 4 digi number prepare by yahoo
spec 1-2-3-4-5 not clear explanation from yahoo and not used in example case from yahoo
display: publish , unpublish
dear vova i konw this explanation is not perfect ,,if you need more explanation please select any part then i will ask directly from yahoo japan
with thanks
best regards

 
18.03.2013 08:51
#6
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

code: Product code(jan) or joomshopping product code?


Last change: 18.03.2013 09:07
 
18.03.2013 09:33
#7
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
Aw: export product to yahoo shopping help need

dear vova
product code could be joomshopping product code,,,but i had not inter such product code in my site so the result will come empty and i have to inter some on my invetory number instad manulaly,,please see screen shot,,
surely i do not mean product id ,,,this product id of joomshopping do not have place for use in yahoo
so please use just product code for joomshopping ,,,,and i do not have JAN for my product
i hope this explanation works
best regards
ariyagallery
Aw: export product to yahoo shopping help need

 
18.03.2013 10:05
#8
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

dear Ariya!
I think your name of product consists of the name and the product code - it's not correct, I can't get code.
Aw: export product to yahoo shopping help need

 
18.03.2013 10:07
#9
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

I'll use Product code.
Aw: export product to yahoo shopping help need

 
18.03.2013 10:12
#10
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
Aw: export product to yahoo shopping help need

dera vova
thanks
that is ok ,,,if it works no problem ,,if not then i will change by hand
please go ahead with that
thanks
ariyagallery

 
18.03.2013 10:15
#11
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

You must fill in this field.
You can show or not this field in the product.
Aw: export product to yahoo shopping help need

 
18.03.2013 10:52
#12
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
Aw: export product to yahoo shopping help need

dear viv
i konw product code ,,i did not use that intetionally becouse i did not like the way it appear ,,refer to screen shot
but now you can use product code ,,then i will decide that to do ,,maybe i put product code for all product or insert it by hand to csv file as it is a must for yahoo
so please arrange the addon as product code appear even though i do not have use that
best regrdas
ariyagallery
Aw: export product to yahoo shopping help need

 
18.03.2013 11:18
#13
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

I must use product code to get relevant link ( related product)
Another way: relevant link will be empty.
Aw: export product to yahoo shopping help need

 
18.03.2013 12:00
#14
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

http://www.webdesigner-profi.de/joomla-webdesign/shop/import-export/export-yahoo-shopping.html?lang=en

 
19.03.2013 08:38
#15
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
Aw: export product to yahoo shopping help need

dear vova
thanks for you help
i bought the addon and install and get csv but becouse of language problem( the japanese language do not show properly in csv) i try to use openoffice
upon importing the csv to openoffice this message come and only afew product import in openoffice
mesagge: the maximum number of row has been exeeded,,exess row not imported
i have about 1000 product in my site but only 26 product import in openoffice.
would you help me on this matter
another question : can i dellet any of this element in this addon which i might think no need or can i change the priority of one of those from any to reqired as for product-category was the same and i changed from any to reqired does this make any problem?
your help is really appreciated
best regards
ariyagallery

 
19.03.2013 10:29
#16
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
Aw: export product to yahoo shopping help need

dear vova
according to your advise to put product code to be able to get relevant link i am doing to put product code for all product in my site even though i do not publish (product code ) in my site
so i think there will be no problem with product code if the previous problem ( exeeding row in csv)
get solved
waiting for your advise
best regards
ariyagallery

 
19.03.2013 13:03
#17
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

dear Ariya!

What Character encoding you are using? Are you changed different Character encoding when make export?
Aw: export product to yahoo shopping help need

 
19.03.2013 13:06
#18
Vova
Joomshopping forum user no avatar
Name: Volodymyr
08.11.2010
Posts: 30
Quote
Aw: export product to yahoo shopping help need

You can delete unused fields or make it unpublish.
Priority only information for you, is not used.


Last change: 19.03.2013 13:12
 
19.03.2013 14:46
#19
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
Aw: export product to yahoo shopping help need

dear vova
thanks for your reply
first as i did not konw which character encoding i must choose ,,, i select utf- 8 ( as in amazoon it was the same) but after receving row exeed error then i try to select enother encode but it gives database error and do no give any export file ,,, i try to reach to yahoo shopping ( japanese) to ask for right character encoding but did not received cleare answer,they will search and anwser later!!!!
any how i have only UTF-8 encode character export and it give row exeed error,,
with thanks
best regards
ariyagaller

 
19.03.2013 14:53
#20
gallery
User gallery
Name: ariya
25.06.2011
Posts: 153
Quote
Aw: export product to yahoo shopping help need

dear vova
do you konw which character encoding i should use for japanese language
do yo think where can i find some information about japanese character encode using in yahoo shop
your help will be appreciated
kind regards
ariyagallery

 
StartPrev 1 2 NextEnd


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.