gcsync

Sie haben einen Artikel in CAO-Faktura angelegt, der in ebay hochgeladen werden soll ?

So gehts: In CAO-Faktura legen Sie eine weitere Warengruppe an, meinetwegen ebay. Dort legen Sie Ihre für ebay vorgesehene Artikel rein.

Unter Export-Tools wird ein neuer Datensatz angelegt: z.B: export nach Turbolister.

Kopieren Sie unter SQL den unten angeführten SQL-Befehl hinein. Die ID der Warengruppe müssen Sie Ihrer natürlich anpassen.

Durch klicken auf Ausführen und Export erhalten Sie eine CSV-Datei, die Turbolister fehlerfrei einliest.

select
77 as 'Site',
1 as 'Format',
7 as 'Currency',
kurzname as 'Title',
'' as 'SubtitleText',
0 as 'Custom Label',
shop_langtext as 'Description',
0 as 'Category 1',
0 as 'Category 2',
0 as 'Store Category',
0 as 'Store Category 2',
shop_image as 'PicURL',
1 as 'Quantity',
'' as 'LotSize',
5 as 'Duration',
vk5b as 'Starting Price',
'' as 'BIN Price',
0 as 'Private Auction',
5 as 'Counter',
1 as 'Buyer pays shipping',
'Zahlungshinweise' as 'Payment Instructions',
1 as 'Specifying Shipping Costs',
0 as 'Accept PayPal',
'email@payl.de' as 'PayPal Email Address',
0 as 'Accept COD',
0 as 'Payment See Description',
1 as 'Accept Money Xfer',
0 as 'CCAccepted',
1 as 'CashOnPickupAccepted',
1 as 'MoneyXferAccepted',
0 as 'MoneyXferAcceptedinCheckout',
0 as 'Escrow',
'' as 'Location - City/State',
'DE' as 'Location - Country',
0 as 'Title Bar Image',
1 as 'Gallery1.Gallery',
0 as 'Gallery Featured',
0 as 'FeaturedFirstDuration',
1 as 'Gallery URL',
0 as 'PicInDesc',
0 as 'PhotoOneRadio',
shop_image as 'PhotoOneURL',
0 as 'Gallery2.GalleryPlus',
0 as 'Bold',
0 as 'Border',
0 as 'LE.Highlight',
0 as 'Featured Plus',
0 as 'Home Page Featured',
0 as 'ThemeId',
0 as 'LayoutId',
0 as 'Apply Multi-item Shipping Discount',
0 as 'VATPercent',
artnum as 'ProductID',
0 as 'UseStockPhotoURLAsGallery',
0 as 'IncludeStockPhotoURL',
0 as 'IncludeProductInfo',
0 as 'UniqueIdentifier',
'24784' as 'Zip',
0 as 'NowAndNew',
0 as 'LE.ProPackBundle',
0 as 'BestOfferEnabled',
0 as 'Item.ExportedImages',
0 as 'PhotoDisplayType',
1 as 'UserHostedOptimizePictureWellBitmap',
0 as 'BuyerResponsibleForShipping',
5 as 'DispatchTimeMax',
0 as 'AutoDecline',
0 as 'ListingDetails/MinimumBestOfferPrice',
0 as 'LE.ValuePackBundle',
0 as 'LE.ProPackPlusBundle',
0 as 'LocalOnlyChk',
0 as 'ContactPrimaryPhone',
0 as 'ContactSecondaryPhone',
0 as 'LocationInfo',
0 as 'ExtendedSellerContactDetails/ClassifiedAdContactByEmailEnabled',
0 as 'ppl_PhoneEnabled',
0 as 'BuyerRequirements/ShipToRegistrationCountry',
0 as 'BuyerRequirements/ZeroFeedbackScore',
0 as 'BuyerRequirements/MinimumFeedbackScore',
0 as 'BuyerRequirements/MaximumUnpaidItemStrikes',
0 as 'BuyerRequirements/MaximumItemRequirements/MaximumItemCount',
0 as 'BuyerRequirements/MaximumItemRequirements/MinimumFeedbackScore',
0 as 'BuyerRequirements/VerifiedUserRequirements/VerifiedUser',
0 as 'BuyerRequirements/VerifiedUserRequirements/MinimumFeedbackScore',
0 as 'DisableBuyerRequirements',
0 as 'InternationalShippingType',
0 as 'Domestic Profile Discount',
0 as 'International Profile Discount',
0 as 'Apply Profile Domestic',
0 as 'Apply Profile International',
0 as 'SellerTags',
0 as 'AutoAccept',
0 as 'ListingDetails/BestOfferAutoAcceptPrice'
from artikel where warengruppe=1