$("#ray_9291").html("\n
1<\/a>
2<\/a>
3<\/a>
4<\/a>
5<\/a>
6<\/a>
7<\/a>
8<\/a>
9<\/a>
10<\/a><\/strong>
11<\/a>
12<\/a>
13<\/a>
14<\/a>
15<\/a>
16<\/a>
17<\/a>
18<\/a>
19<\/a>
20<\/a><\/strong>
21<\/a>
22<\/a>
23<\/a>
24<\/a>
25<\/a>
26<\/a>
27<\/a>
28<\/a>
29<\/a>
30<\/a><\/strong>
31<\/a>
32<\/a>
33<\/a>
34<\/a>
35<\/a>
36<\/a>
37<\/a>
38<\/a>
39<\/a>
40<\/a><\/strong>
41<\/a>
42<\/a>
43<\/a>
44<\/a>
45<\/a>
46<\/a>
47<\/a>
48<\/a>
49<\/a>
50<\/a><\/strong>
51<\/a>
52<\/a>
53<\/a>
54<\/a>
55<\/a>
56<\/a>
57<\/a>
58<\/a>
59<\/a>
60<\/a><\/strong>
61<\/a>
62<\/a>
63<\/a>
64<\/a>
65<\/a>
66<\/a>
67<\/a>
68<\/a>
69<\/a>
70<\/a><\/strong>
71<\/a>
72<\/a>
73<\/a>
74<\/a>
75<\/a>
76<\/a>
77<\/a>
78<\/a>
79<\/a>
80<\/a><\/strong>
81<\/a><\/pre><\/td>\n  
p_new<\/span> <\/span>=<\/span> <\/span>product<\/span>
<\/span>if<\/span> <\/span>r1<\/span>.<\/span>nil?<\/span>
<\/span>  <\/span>puts<\/span> <\/span>"<\/span>!! <\/span>#{<\/span>item_id<\/span>}<\/span><\/span> no product found in ERP<\/span>"<\/span><\/span>
<\/span>  <\/span>return<\/span> <\/span>"<\/span>"<\/span><\/span>
<\/span>end<\/span>
<\/span>
<\/span>if<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Vintage<\/span>"<\/span><\/span>]<\/span>.<\/span>to_i<\/span> <\/span>><\/span> <\/span>1000<\/span>
<\/span>  <\/span>p_new<\/span>.<\/span>title<\/span> <\/span>=<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Vintage<\/span>"<\/span><\/span>]<\/span> <\/span>+<\/span> <\/span>"<\/span> <\/span>"<\/span><\/span> <\/span>+<\/span> <\/span>r1<\/span>[<\/span>"<\/span>LongTitle<\/span>"<\/span><\/span>]<\/span>
<\/span>else<\/span>
<\/span>  <\/span>p_new<\/span>.<\/span>title<\/span> <\/span>=<\/span> <\/span>r1<\/span>[<\/span>"<\/span>LongTitle<\/span>"<\/span><\/span>]<\/span>
<\/span>end<\/span>
<\/span>
<\/span>vol<\/span> <\/span>=<\/span> <\/span>(<\/span>r1<\/span>[<\/span>"<\/span>Volume<\/span>"<\/span><\/span>]<\/span>.<\/span>to_f<\/span>*<\/span>1000<\/span>)<\/span>.<\/span>to_i<\/span>
<\/span>if<\/span> <\/span>(<\/span>vol<\/span> <\/span><<\/span> <\/span>700<\/span> <\/span>or<\/span> <\/span>vol<\/span> <\/span>><\/span> <\/span>799<\/span>)<\/span> <\/span>and<\/span> <\/span>vol<\/span> <\/span>><\/span> <\/span>1<\/span>
<\/span>  <\/span>p_new<\/span>.<\/span>title<\/span> <\/span>=<\/span> <\/span>p_new<\/span>.<\/span>title<\/span> <\/span>+<\/span> <\/span>"<\/span> (<\/span>"<\/span><\/span> <\/span>+<\/span> <\/span>vol<\/span>.<\/span>to_s<\/span> <\/span>+<\/span> <\/span>"<\/span> ml)<\/span>"<\/span><\/span>
<\/span>end<\/span>
<\/span>
<\/span>if<\/span> <\/span>p_new<\/span>.<\/span>handle?<\/span>.<\/span>nil?<\/span> <\/span>or<\/span> <\/span>"<\/span>"<\/span><\/span> <\/span>==<\/span> <\/span>p_new<\/span>.<\/span>handle<\/span>
<\/span>  <\/span>p_new<\/span>.<\/span>handle<\/span> <\/span>=<\/span> <\/span>(<\/span>r1<\/span>[<\/span>"<\/span>LongTitle<\/span>"<\/span><\/span>]<\/span>+<\/span>"<\/span>-<\/span>"<\/span><\/span>+<\/span>r1<\/span>[<\/span>"<\/span>Vintage<\/span>"<\/span><\/span>]<\/span>+<\/span>"<\/span>-<\/span>"<\/span><\/span>+<\/span>r1<\/span>[<\/span>"<\/span>ItemID<\/span>"<\/span><\/span>]<\/span>)<\/span>.<\/span>downcase<\/span>.<\/span>gsub<\/span>(<\/span>/<\/span>[^a-z0-9]<\/span>/<\/span><\/span>,<\/span>"<\/span> <\/span>"<\/span><\/span>)<\/span>.<\/span>strip<\/span>.<\/span>gsub<\/span>(<\/span>"<\/span> <\/span>"<\/span><\/span>,<\/span>"<\/span>-<\/span>"<\/span><\/span>)<\/span>
<\/span>end<\/span>
<\/span>
<\/span>vendor_re<\/span> <\/span>=<\/span> <\/span>/<\/span>.*<\/span>\\s<\/span>?-<\/span>\\s<\/span>(.*)|.*(Domaine.*)|(.*)<\/span>/<\/span><\/span>
<\/span>
<\/span>p_new<\/span>.<\/span>vendor<\/span> <\/span>=<\/span> <\/span>r1<\/span>[<\/span>"<\/span>LongTitle<\/span>"<\/span><\/span>]<\/span>.<\/span>match<\/span>(<\/span>vendor_re<\/span>)<\/span>.<\/span>to_a<\/span>[<\/span>1<\/span>..<\/span>3<\/span>]<\/span>.<\/span>join<\/span>(<\/span>)<\/span>
<\/span>if<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Reference3<\/span>"<\/span><\/span>]<\/span> <\/span>!=<\/span> <\/span>"<\/span>"<\/span><\/span>
<\/span>  <\/span>p_new<\/span>.<\/span>vendor<\/span> <\/span>=<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Reference3<\/span>"<\/span><\/span>]<\/span>
<\/span>  <\/span>puts<\/span> <\/span>p_new<\/span>.<\/span>vendor<\/span>
<\/span>end<\/span>
<\/span>p_new<\/span>.<\/span>product_type<\/span> <\/span>=<\/span> <\/span>r1<\/span>[<\/span>"<\/span>ItemType<\/span>"<\/span><\/span>]<\/span>.<\/span>gsub<\/span>(<\/span>"<\/span>00_<\/span>"<\/span><\/span>,<\/span>"<\/span>"<\/span><\/span>)<\/span>.<\/span>capitalize<\/span>
<\/span>
<\/span>country_s<\/span> <\/span>=<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Country<\/span>"<\/span><\/span>]<\/span>.<\/span>capitalize<\/span>
<\/span>country_s<\/span> <\/span>=<\/span> <\/span>"<\/span>USA<\/span>"<\/span><\/span> <\/span>if<\/span> <\/span>country_s<\/span>.<\/span>downcase<\/span> <\/span>==<\/span> <\/span>"<\/span>usa<\/span>"<\/span><\/span>
<\/span>country_s<\/span> <\/span>=<\/span> <\/span>"<\/span>United Kingdom<\/span>"<\/span><\/span> <\/span>if<\/span> <\/span>country_s<\/span>.<\/span>downcase<\/span> <\/span>==<\/span> <\/span>"<\/span>uk<\/span>"<\/span><\/span>
<\/span>
<\/span>tags<\/span> <\/span>=<\/span> <\/span>[<\/span>]<\/span>
<\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>appellation-<\/span>"<\/span><\/span> <\/span>+<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Appellation<\/span>"<\/span><\/span>]<\/span>.<\/span>gsub<\/span>(<\/span>"<\/span>_AOC<\/span>"<\/span><\/span>,<\/span>"<\/span>"<\/span><\/span>)<\/span>.<\/span>gsub<\/span>(<\/span>"<\/span>_<\/span>"<\/span><\/span>,<\/span>"<\/span> <\/span>"<\/span><\/span>)<\/span>.<\/span>capitalize<\/span>
<\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>country-<\/span>"<\/span><\/span> <\/span>+<\/span> <\/span>country_s<\/span>
<\/span>tags<\/span>.<\/span>push<\/span> <\/span>p_new<\/span>.<\/span>product_type<\/span>
<\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>region-<\/span>"<\/span><\/span> <\/span>+<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Region<\/span>"<\/span><\/span>]<\/span>.<\/span>capitalize<\/span>
<\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>size-<\/span>#{<\/span>vol<\/span>}<\/span><\/span>ml<\/span>"<\/span><\/span> <\/span>if<\/span> <\/span>vol<\/span> <\/span>><\/span> <\/span>10<\/span>
<\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>vintage-<\/span>#{<\/span>r1<\/span>[<\/span>"<\/span>Vintage<\/span>"<\/span><\/span>]<\/span>}<\/span><\/span>"<\/span><\/span>
<\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>wine<\/span>"<\/span><\/span>  <\/span># if not asso / cigar<\/span>
<\/span>if<\/span> <\/span>not<\/span> <\/span>r1<\/span>[<\/span>"<\/span>ZhName<\/span>"<\/span><\/span>]<\/span>.<\/span>match<\/span>(<\/span>/<\/span>\\p<\/span>{Han}<\/span>/<\/span><\/span>)<\/span>.<\/span>nil?<\/span>
<\/span>  <\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>zh-<\/span>#{<\/span>r1<\/span>[<\/span>"<\/span>ZhName<\/span>"<\/span><\/span>]<\/span>}<\/span><\/span>"<\/span><\/span>
<\/span>end<\/span>
<\/span>
<\/span>score_h<\/span> <\/span>=<\/span> <\/span>0<\/span>
<\/span>r1<\/span>[<\/span>"<\/span>Score<\/span>"<\/span><\/span>]<\/span>.<\/span>split<\/span>(<\/span>"<\/span>,<\/span>"<\/span><\/span>)<\/span>.<\/span>each<\/span> <\/span>do<\/span> <\/span>|<\/span>s<\/span>|<\/span>
<\/span>  <\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>score-<\/span>#{<\/span>s<\/span>}<\/span><\/span>"<\/span><\/span>
<\/span>  <\/span>score<\/span> <\/span>=<\/span> <\/span>s<\/span>.<\/span>match<\/span>(<\/span>/<\/span>\\d<\/span>+<\/span>/<\/span><\/span>)<\/span>.<\/span>to_s<\/span>.<\/span>to_i<\/span>
<\/span>  <\/span>score_h<\/span> <\/span>=<\/span> <\/span>score<\/span> <\/span>if<\/span> <\/span>score<\/span> <\/span>><\/span> <\/span>score_h<\/span>
<\/span>end<\/span>
<\/span>
<\/span>if<\/span> <\/span>score_h<\/span> <\/span>><\/span>=<\/span> <\/span>99<\/span>
<\/span>  <\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>score-A<\/span>"<\/span><\/span>
<\/span>elsif<\/span> <\/span>score_h<\/span> <\/span>><\/span>=<\/span> <\/span>95<\/span> <\/span>and<\/span> <\/span>score_h<\/span> <\/span><=<\/span> <\/span>98<\/span>
<\/span>  <\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>score-B<\/span>"<\/span><\/span>
<\/span>elsif<\/span> <\/span>score_h<\/span> <\/span>><\/span>=<\/span> <\/span>90<\/span> <\/span>and<\/span> <\/span>score_h<\/span> <\/span><=<\/span> <\/span>94<\/span>
<\/span>  <\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>score-C<\/span>"<\/span><\/span>
<\/span>elsif<\/span> <\/span>score_h<\/span> <\/span><<\/span> <\/span>90<\/span> <\/span>and<\/span> <\/span>score_h<\/span> <\/span>><\/span>=<\/span> <\/span>60<\/span>
<\/span>  <\/span>tags<\/span>.<\/span>push<\/span> <\/span>"<\/span>score-D<\/span>"<\/span><\/span>
<\/span>end<\/span>
<\/span>
<\/span>p_new<\/span>.<\/span>tags<\/span> <\/span>=<\/span> <\/span>tags<\/span>.<\/span>join<\/span>(<\/span>"<\/span>, <\/span>"<\/span><\/span>)<\/span>
<\/span>
<\/span>if<\/span> <\/span>p_new<\/span>.<\/span>new?<\/span>
<\/span>  <\/span>v_new<\/span> <\/span>=<\/span> <\/span>Variant<\/span>.<\/span>new<\/span>
<\/span>else<\/span>
<\/span>  <\/span>v_new<\/span> <\/span>=<\/span> <\/span>p_new<\/span>.<\/span>variants<\/span>.<\/span>first<\/span>
<\/span>end<\/span>
<\/span>
<\/span>v_new<\/span>.<\/span>price<\/span> <\/span>=<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Price2<\/span>"<\/span><\/span>]<\/span>.<\/span>to_i<\/span>
<\/span>v_new<\/span>.<\/span>compare_at_price<\/span> <\/span>=<\/span>  <\/span>r1<\/span>[<\/span>"<\/span>Price2<\/span>"<\/span><\/span>]<\/span> <\/span>==<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Price3<\/span>"<\/span><\/span>]<\/span>  <\/span>?<\/span> <\/span>0<\/span> <\/span>:<\/span> <\/span>r1<\/span>[<\/span>"<\/span>Price3<\/span>"<\/span><\/span>]<\/span>.<\/span>to_i<\/span>
<\/span>
<\/span>v_new<\/span>.<\/span>sku<\/span> <\/span>=<\/span> <\/span>r1<\/span>[<\/span>"<\/span>ItemID<\/span>"<\/span><\/span>]<\/span>
<\/span>v_new<\/span>.<\/span>gram<\/span> <\/span>=<\/span> <\/span>vol<\/span> <\/span>*<\/span> <\/span>2<\/span> <\/span>if<\/span> <\/span>vol<\/span> <\/span>><\/span> <\/span>1<\/span>
<\/span>#v_new.inventory_quantity = r1["AvaQty"].to_i<\/span>
<\/span>#v_new.inventory_quantity = 0 if v_new.price == 0<\/span>
<\/span>v_new<\/span>.<\/span>inventory_management<\/span> <\/span>=<\/span> <\/span>"<\/span>shopify<\/span>"<\/span><\/span>
<\/span>v_new<\/span>.<\/span>taxable<\/span> <\/span>=<\/span> <\/span>false<\/span>
<\/span>v_new<\/span>.<\/span>weight<\/span> <\/span>=<\/span> <\/span>(<\/span>vol<\/span> <\/span>*<\/span> <\/span>2.0<\/span> <\/span>/<\/span> <\/span>1000<\/span>)<\/span> <\/span>if<\/span> <\/span>vol<\/span> <\/span>><\/span> <\/span>1<\/span>
<\/span><\/pre><\/td>\n<\/tr><\/table>\n\n");