Beiträge von admin

  • Wiso Mein Büro Shopanbindung erkennt Paypalorders nicht.

    Laut Doku nehmen die die Schnittstelle von orgamax. Hm, da habe ich keine gute Erfahrung. Wird denn nur die Bestellung per PayPal nicht importiert, die anderen schon? Da musst Du wirklich bei Anbieter der WAWI fragen, denn die Bestellung ist exakt gleich wie alle anderen, nur halt mit dem Status PayPal bezahlt. Eventuell hilft es, PayPal so einzustellen, dass der Status bei erfolgreicher Bestellung auf Offen ist, was aber nicht besonders sinnvoll ist.

  • FixPack1 für commerce:SEO v2.2.0.2

    Kleiner Nachtrag noch, Blog wurde soebend noch gefixt. Sind nur 2 Dateien.
    /blog.php
    und
    /includes/modules/metatags.php

    Sind jetzt im FP1 mit drin.
    Ich denke, mit dem FP1 läuft es jetzt wirklich lagsam rund. haben nun schon diverse projekte umgestellt und keine Bugs mehr fest gestellt.

  • FixPack1 für commerce:SEO v2.2.0.2

    SQL für enlischen Newsletter


    2. Newsletter english:

    SQL
    UPDATE emails SET 
email_content_html = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0  Strict//EN"  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html  xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de"  lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type"  content="text/html;charset=utf-8"  />\r\n<title>Newsletter</title>\r\n{literal}\r\n<style  type="text/css">\r\nbody, table {\r\n font-size:11.5px;\r\n  font-family:Helvetica, sans-serif;\r\n  color:#444\r\n}\r\ntable.outerTable {\r\n border: 1px solid  #ccc\r\n}\r\ntd.TopRightDesc {\r\n letter-spacing: 1px;\r\n font-weight:  600\r\n}\r\n.ProductsTable td {\r\n color:#6d88b1;\r\n background:  #f1f1f1\r\n}\r\n.ProductsAttributes td, .ProductsName {\r\n background:  #ffffff\r\n}\r\n.bt {\r\n border-top:1px solid #ccc\r\n}\r\n.bb {\r\n  border-bottom:1px solid #ccc\r\n}\r\n.bl {\r\n border-left:1px solid  #ccc\r\n}\r\n.br {\r\n border-right:1px solid #ccc\r\n}\r\n.fs85 {\r\n  font-size:85%\r\n}\r\n</style>\r\n{/literal}\r\n</head>\r\n<body>\r\n<table  width="90%" border="0" cellpadding="10" cellspacing="0" align="center"  class="outerTable">\r\n <tr>\r\n  <td>\r\n  <table  width="100%" border="0" cellpadding="0" cellspacing="0">\r\n    <tr>\r\n    <td width="50%"><img  src="{$logo_path}logo.gif" alt="" /> </td>\r\n    <td  width="50%" class="TopRightDesc" align="right"> Newsletter  </td>\r\n   </tr>\r\n   </table>\r\n  </td>\r\n  </tr>\r\n <tr>\r\n  <td>\r\n  <div  style="width:95%; background-color:#fff; padding:10px;">\r\n   <h2  style="border-bottom:2px solid #6a0101; padding-bottom:10px;  color:#333;">{$SHOP_NAME} Newsletter</h2>\r\n    <p><strong> {if $personalize == ''yes'' &&  $greeting_type == ''0''} {if $customers_gender == ''f''} Dear  Mrs.{$customers_name}, {else} Dear Mr. {$customers_name}, {/if} {/if}  {if $personalize == ''yes'' && $greeting_type == ''1''} Welcome  {$customers_name}, {/if} {if $personalize == ''''} Dear Customer, {/if}  </strong></p>\r\n   <p>{$body}</p>\r\n   {if  $gift_id}\r\n   {if $greeting_type == ''1''}\r\n   <table  width="100%" style="border:1px #CCC; padding:10px; margin-bottom:15px;  background-color:#ffeded;">\r\n    <tr>\r\n    <td><p  style="padding-bottom:7px; margin:0 0 10px 0;"><strong  style="font-family: Georgia, Times New Roman, Times, serif;  font-size:12px;"><span id="result_box3" lang="en"  xml:lang="en">voucher</span>:</strong></p>\r\n       <span id="result_box" lang="en" xml:lang="en">We will send you a  small gift of a voucher in the amount of</span>  <b>{$gift_ammount}</b>. <br />\r\n      <span  id="result_box2" lang="en" xml:lang="en">Just give when ordering your  personal coupon code</span>:  <b>{$gift_id}</b></td>\r\n    </tr>\r\n    </table>\r\n   {else}\r\n   <table width="100%"  style="border:1px #CCC; padding:10px; margin-bottom:15px;  background-color:#ffeded;">\r\n    <tr>\r\n    <td><p  style="padding-bottom:7px; margin:0 0 10px 0;"><strong  style="font-family: Georgia, Times New Roman, Times, serif;  font-size:12px;"><span id="result_box4" lang="en"  xml:lang="en">voucher</span>:</strong></p>\r\n       <span id="result_box5" lang="en" xml:lang="en">We will send you a  small gift of a voucher in the amount of</span>  <b>{$gift_ammount}</b>. <br />\r\n      <span  id="result_box6" lang="en" xml:lang="en">Just specify when ordering  your personal coupon code</span>:  <b>{$gift_id}</b></td>\r\n    </tr>\r\n    </table>\r\n   {/if}\r\n   {/if}\r\n   <div  style="background:#fff;">\r\n    <table width="100%"  cellpadding="0" cellspacing="0" border="0">\r\n    <tr>  <td>\r\n  {foreach name=aussen item=module_data  from=$module_content}\r\n     <table width="100%" border="0"  cellpadding="10" cellspacing="0" style="border-bottom:1px solid  #999;">\r\n      <tr>\r\n      <td width="20%" rowspan="2"  valign="top" style="border-right:1px solid #999;"><a  href="{$module_data.PRODUCTS_LINK}"> <img  src="{$module_data.PRODUCTS_IMAGE}" alt="{$module_data.PRODUCTS_NAME}"  border="0" class"productImageBorder" /> </a> </td>\r\n       <td width="80%" valign="top"><a  href="{$module_data.PRODUCTS_LINK}"  style="text-decoration:none;">\r\n       <h1  style="font-size:12px;  color:#6a0101;">{$module_data.PRODUCTS_NAME}</h1>\r\n        </a>{$module_data.PRODUCTS_SHORT_DESCRIPTION}\r\n        </td>\r\n      </tr>\r\n      <tr>\r\n      <td  valign="bottom">\r\n       <div style="text-align:right;  border-top:1px solid #000; padding-top:5px; margin-top:10px;">\r\n         <a href="{$module_data.PRODUCTS_LINK}" style="color:#6a0101;  text-decoration:underline;"><b>Buy Now!</b></a> |  <strong>{$module_data.PRODUCTS_PRICE}</strong>\r\n        </div>\r\n      </td>\r\n      </tr>\r\n      </table>\r\n\r\n     {/foreach}</td> </tr>\r\n     </table>\r\n    <div style="text-align:right; font-size:10px;  margin-top:10px;">{$remove_link}</div>\r\n   </div>\r\n    </div>\r\n  </td>\r\n </tr>\r\n</table>',
email_content_text = 'Shopname Newsletter\r\n\r\n{if $personalize ==  ''yes'' && $greeting_type == ''0''} {if $customers_gender ==  ''f''} Dear Mrs.{$customers_name}, {else} Dear Mr. {$customers_name},  {/if} {/if} {if $personalize == ''yes'' && $greeting_type ==  ''1''} Welcome {$customers_name}, {/if} {if $personalize == ''''} Dear  Customer, {/if}\r\n\r\n{$body}\r\n\r\n{if $gift_id} {if $greeting_type  == ''1''} voucher:\r\n\r\nWe will send you a small gift of a voucher in  the amount of {$gift_ammount}\r\nJust give when ordering your personal  coupon code: {$gift_id}\r\n\r\n{else} voucher:\r\n\r\nWe will send you a  small gift of a voucher in the amount of {$gift_ammount}\r\nJust give  when ordering your personal coupon code: {$gift_id}\r\n\r\n{/if} {/if}  {foreach name=aussen item=module_data from=$module_content}  \r\n\r\n{$module_data.PRODUCTS_NAME}\r\n\r\n{$module_data.PRODUCTS_SHORT_DESCRIPTION}\r\n\r\nbuy  now! | {$module_data.PRODUCTS_PRICE} EUR  \r\n\r\n{/foreach}  {$remove_link}',
email_backup_html = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0  Strict//EN"  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html  xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de"  lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type"  content="text/html;charset=utf-8"  />\r\n<title>Newsletter</title>\r\n{literal}\r\n<style  type="text/css">\r\nbody, table {\r\n font-size:11.5px;\r\n  font-family:Helvetica, sans-serif;\r\n  color:#444\r\n}\r\ntable.outerTable {\r\n border: 1px solid  #ccc\r\n}\r\ntd.TopRightDesc {\r\n letter-spacing: 1px;\r\n font-weight:  600\r\n}\r\n.ProductsTable td {\r\n color:#6d88b1;\r\n background:  #f1f1f1\r\n}\r\n.ProductsAttributes td, .ProductsName {\r\n background:  #ffffff\r\n}\r\n.bt {\r\n border-top:1px solid #ccc\r\n}\r\n.bb {\r\n  border-bottom:1px solid #ccc\r\n}\r\n.bl {\r\n border-left:1px solid  #ccc\r\n}\r\n.br {\r\n border-right:1px solid #ccc\r\n}\r\n.fs85 {\r\n  font-size:85%\r\n}\r\n</style>\r\n{/literal}\r\n</head>\r\n<body>\r\n<table  width="90%" border="0" cellpadding="10" cellspacing="0" align="center"  class="outerTable">\r\n <tr>\r\n  <td>\r\n  <table  width="100%" border="0" cellpadding="0" cellspacing="0">\r\n    <tr>\r\n    <td width="50%"><img  src="{$logo_path}logo.gif" alt="" /> </td>\r\n    <td  width="50%" class="TopRightDesc" align="right"> Newsletter  </td>\r\n   </tr>\r\n   </table>\r\n  </td>\r\n  </tr>\r\n <tr>\r\n  <td>\r\n  <div  style="width:95%; background-color:#fff; padding:10px;">\r\n   <h2  style="border-bottom:2px solid #6a0101; padding-bottom:10px;  color:#333;">{$SHOP_NAME} Newsletter</h2>\r\n    <p><strong> {if $personalize == ''yes'' &&  $greeting_type == ''0''} {if $customers_gender == ''f''} Dear  Mrs.{$customers_name}, {else} Dear Mr. {$customers_name}, {/if} {/if}  {if $personalize == ''yes'' && $greeting_type == ''1''} Welcome  {$customers_name}, {/if} {if $personalize == ''''} Dear Customer, {/if}  </strong></p>\r\n   <p>{$body}</p>\r\n   {if  $gift_id}\r\n   {if $greeting_type == ''1''}\r\n   <table  width="100%" style="border:1px #CCC; padding:10px; margin-bottom:15px;  background-color:#ffeded;">\r\n    <tr>\r\n    <td><p  style="padding-bottom:7px; margin:0 0 10px 0;"><strong  style="font-family: Georgia, Times New Roman, Times, serif;  font-size:12px;"><span id="result_box3" lang="en"  xml:lang="en">voucher</span>:</strong></p>\r\n       <span id="result_box" lang="en" xml:lang="en">We will send you a  small gift of a voucher in the amount of</span>  <b>{$gift_ammount}</b>. <br />\r\n      <span  id="result_box2" lang="en" xml:lang="en">Just give when ordering your  personal coupon code</span>:  <b>{$gift_id}</b></td>\r\n    </tr>\r\n    </table>\r\n   {else}\r\n   <table width="100%"  style="border:1px #CCC; padding:10px; margin-bottom:15px;  background-color:#ffeded;">\r\n    <tr>\r\n    <td><p  style="padding-bottom:7px; margin:0 0 10px 0;"><strong  style="font-family: Georgia, Times New Roman, Times, serif;  font-size:12px;"><span id="result_box4" lang="en"  xml:lang="en">voucher</span>:</strong></p>\r\n       <span id="result_box5" lang="en" xml:lang="en">We will send you a  small gift of a voucher in the amount of</span>  <b>{$gift_ammount}</b>. <br />\r\n      <span  id="result_box6" lang="en" xml:lang="en">Just specify when ordering  your personal coupon code</span>:  <b>{$gift_id}</b></td>\r\n    </tr>\r\n    </table>\r\n   {/if}\r\n   {/if}\r\n   <div  style="background:#fff;">\r\n    <table width="100%"  cellpadding="0" cellspacing="0" border="0">\r\n    <tr>  <td>\r\n  {foreach name=aussen item=module_data  from=$module_content}\r\n     <table width="100%" border="0"  cellpadding="10" cellspacing="0" style="border-bottom:1px solid  #999;">\r\n      <tr>\r\n      <td width="20%" rowspan="2"  valign="top" style="border-right:1px solid #999;"><a  href="{$module_data.PRODUCTS_LINK}"> <img  src="{$module_data.PRODUCTS_IMAGE}" alt="{$module_data.PRODUCTS_NAME}"  border="0" class"productImageBorder" /> </a> </td>\r\n       <td width="80%" valign="top"><a  href="{$module_data.PRODUCTS_LINK}"  style="text-decoration:none;">\r\n       <h1  style="font-size:12px;  color:#6a0101;">{$module_data.PRODUCTS_NAME}</h1>\r\n        </a>{$module_data.PRODUCTS_SHORT_DESCRIPTION}\r\n        </td>\r\n      </tr>\r\n      <tr>\r\n      <td  valign="bottom">\r\n       <div style="text-align:right;  border-top:1px solid #000; padding-top:5px; margin-top:10px;">\r\n         <a href="{$module_data.PRODUCTS_LINK}" style="color:#6a0101;  text-decoration:underline;"><b>Buy Now!</b></a> |  <strong>{$module_data.PRODUCTS_PRICE}</strong>\r\n        </div>\r\n      </td>\r\n      </tr>\r\n      </table>\r\n\r\n     {/foreach}</td> </tr>\r\n     </table>\r\n    <div style="text-align:right; font-size:10px;  margin-top:10px;">{$remove_link}</div>\r\n   </div>\r\n    </div>\r\n  </td>\r\n </tr>\r\n</table>',
email_backup_text = 'Shopname Newsletter\r\n\r\n{if $personalize ==  ''yes'' && $greeting_type == ''0''} {if $customers_gender ==  ''f''} Dear Mrs.{$customers_name}, {else} Dear Mr. {$customers_name},  {/if} {/if} {if $personalize == ''yes'' && $greeting_type ==  ''1''} Welcome {$customers_name}, {/if} {if $personalize == ''''} Dear  Customer, {/if}\r\n\r\n{$body}\r\n\r\n{if $gift_id} {if $greeting_type  == ''1''} voucher:\r\n\r\nWe will send you a small gift of a voucher in  the amount of {$gift_ammount}\r\nJust give when ordering your personal  coupon code: {$gift_id}\r\n\r\n{else} voucher:\r\n\r\nWe will send you a  small gift of a voucher in the amount of {$gift_ammount}\r\nJust give  when ordering your personal coupon code: {$gift_id}\r\n\r\n{/if} {/if}  {foreach name=aussen item=module_data from=$module_content}  \r\n\r\n{$module_data.PRODUCTS_NAME}\r\n\r\n{$module_data.PRODUCTS_SHORT_DESCRIPTION}\r\n\r\nbuy  now! | {$module_data.PRODUCTS_PRICE} EUR  \r\n\r\n{/foreach}  {$remove_link}'
WHERE email_name = 'newsletter'
AND languages_id = '1';