Support Center

Connecting to Gambio

Follow

 

Shopgate supports Gambio as a shopping cart system.

By setting up the Shopgate plugin for your Gambio shop, you will get these wonderful features straight into your mobile shop and apps:

Supported Version Import to Gambio

GX1, 2, 3

  Orders
Sync Export to Shopgate Mobile Shop

Delivery Status "Shipped"
Order Status "Canceled"
Stock Quantity, on Product Detail Page



Products
Categories
Reviews



Customer Account Validate, upon Cart Changes

Login with Desktop Shop Account
Login to Desktop Shop with Mobile Account
Customer Groups / Tier Pricing
Show Desktop Orders on Mobile



/
Coupon
Shipping Method
Payment Method
Product Availability



Supported Payments Notes

Prepayment, Direct Debit, PayPal, Cash on Delivery

N/A

 

In this article, you will find everything you need to set up the Shopgate plugin for your Gambio shop.

 

Topics covered in this article:

  1. Installing the Shopgate Plugin
  2. Establishing connection between the plugin and the Shopgate system
  3. Updating an existing Shopgate plugin
  4. Configuring the Plugin
  5. Adjusting codes for earlier Gambio versions
  6. Frequently Asked Questions (FAQ)

 

1. Installing the Shopgate Plugin

The Shopgate plugin for Gambio can be installed in all Gambio versions starting from 1.4.0.0. To do this, please follow the 3 points here:

1.1 Downloading the plugin

Download the plugin via this link: http://files.shopgate.com/plugins/gambiogx.zip and extract the contents of the zip file.

 

1.2 Uploading the plugin to your server

To upload files to your FTP server, you will need an FTP client tool. Plenty of FTP programs can be found on the internet. FileZilla is used in the example below. (How to install and use FileZilla?)

  1. Once your FTP program is connected to your server, navigate to the extracted Shopgate plugin in your local directory (left), and your shopping cart folder on the FTP server (right). Select ALL files in your Shopgate plugin local folder and drag them into your shop folder. Upload will start immediately. Click Yes if you are asked to override a folder.
  2. Give the "temp" and "config" folders the right permissions for the plugin to work correctly. In your shop folder on FTP server, navigate to "../Gambio/shopgate/shopgate_library". Select folders config and temp, right-click on the folders, and select "File Permissions...".
  3. Give both folders Write permissions, set value 774*, and select Apply to all data and files. Click OK to finish the upload.
    * If you cannot save your changes or configurations, set file permissions to 777.

 

1.3 Activating the plugin in your Gambio backend

Important: If you're using an older version of Gambio, you will need to add a few lines of codes in your Gambio files. Refer to Chapter 5: Adjusting codes for more information.
1. Log in to your Gambio admin backend and go to Modules > Payment Systems on the left.
2. On the Payment Modules page, click on Mobile > Shopgate (shopgate).
3. A small pop-up will now show up on the top-right of the screen. Click Install.
4. Clear cache by clicking the  next to the LOG OUT button on the top right. Alternatively, go to TOOLBOX > Clear Cache on the left then click on "Empty Modules Cache".
5. Your plugin is installed successfully in Gambio if you see a new menu entry SHOPGATE on the left.

 

Click on "2. Basic Settings" to open the Settings page for the Shopgate plugin. Leave this page open - we will explain how to find the required info in the next chapters.

 

2. Establishing connections between the plugin and Shopgate

After the Shopgate plugin has been installed successfully, 2 simple tasks need to be done to connect your mobile shop at Shopgate to your shop's backend: to enter API credentials in your shop's backend, and to enter your shop's URL in your Shopgate's admin page. 

2.1 Getting API credentials

  1. Log in to your Shopgate Admin page.
  2. Click on Integration from the menu bar, then select Install Interface.
  3. In the drop-down labeled Select system, search for Gambio and select it.
  4. A popup opens. Look for Customer number, Shop number, API key, and Alias under 2. Configure. These are the API credentials the plugin needs to authenticate at the Shopgate backend. Leave this page open - we will come back to enter the URL (explained in 2.2 Establishing connection)
  5. Copy Customer number, Shop number, API key, and Alias, and paste them individually onto the plugin configuration page you left open above. The rest of the options can be configured later. This is explained in Chapter 4. Configuring the Plugin). Click Save.

 

2.2 Connecting your shop to Shopgate

  1. Go back to the pop-up window at your Shopgate merchant page (step 4).
  2. Under "3. Enter URL", enter the URL of your shop, ideally starting with “https://”. For example: https://www.MyAwesomeShop.com. Click connect to establish the interface.
  3. If a connection is made successfully, a popup shown below will open. Here you will be able to assign jobs for your first connection. We recommend to leave all assignments to ON at this time. Click Save.
  4. That's it! Now the Shopgate backend will automatically start to import product data via the newly established interface. And welcome to the mobile world :)

 

3. Updating an existing Shopgate plugin

3.1 Checking for custom adaption

Before updating your Shopgate plugin to a newer version, make sure to check if your shop uses a customized version of the Shopgate plugin. If this is the case, a generic plugin update will NOT work for your shop.

To check if your plugin is customized...

You are using a customized version if

  • you have contacted Shopgate for making a 3rd party plugin to work in your mobile shop, or adding a special feature/function
  • Shopgate has sent you an adapted version of plugin
  • the plugin file you installed has "adaption" in the name

If your shop uses a customized Shopgate plugin...

Please email Shopgate each time before updating with the following details:

 

3.2 Updating the plugin

To update a previously installed Shopgate plugin to the latest version, follow the steps here:

  1. Uninstall the old plugin by clicking on the Uninstall button shown below.
  2. To update a customized Shopgate plugin, follow chapter 1.2 to upload the customized Shopgate plugin (the one you received in the email).
    To update a generic Shopgate plugin, follow chapters 1.1 to download the latest version and 1.2 to upload it to your server.
  3. Now follow chapter 1.3 to activate the plugin in your Gambio backend.

 

4. Configuring the Plugin in Gambio

To configure your Shopgate plugin in your Gambio admin, please find the Shopgate entry on the left and click Settings.

 

Please find the detailed explanations of each option below.

4.1 Connection Settings

 

4.2 Mobile Redirect

Set up your mobile website and redirect.

Shopgate module activated

Select Yes to activate your mobile shop.

Shop alias

Your shop alias is a unique identifier of your shop at Shopgate. It is automatically generated based on the shop name you entered at registration.

To understand and find your shop alias, read Customizing mobile URL (alias) within the Shopgate domain

Custom URL to mobile webpage (CNAME)

A CNAME is a subdomain of your own domain that points to your mobile website. It could look like this http://m.myawesomeshop.com

To understand and set up CNAME, read Setting up mobile URL within your shop domain

Redirected languages Select language(s) for your mobile shop.

 

4.3 Exporting Categories and Products

Choose how your products should be exported.

Language Choose the language the products should be exported in.
Currency Choose the currency your products should be exported in.
Country Choose the country your products should be exported for.
Tax zone for Shopgate Choose the tax zone your products will be exported for. This will calculate the tax rates to be exported for your products.
Reverse category sort order Choose "Yes" if categories in your mobile shop appear to be sorted upside down.
Reverse products sort order Choose "Yes" if products in your mobile shop appear to be sorted upside down.
Products description Choose between the short description, the long description or a combination of both to be used for exporting your products to Shopgate.
Price group for Shopgate Choose the price group products will be exported for to Shopgate.
Variation type Choose if you’d like to export products using Gambio “options” or “properties”. When choosing “Both variation types” products with either “options” or “properties” will be exported. Note that products using both types will be omitted regardless of this setting.
Export “price on request” products Choose "with price" to show the products prices even if their price status is set to "price on request". The setting "without price" will export a price amount of zero including the information, that the price needs to be requested.
Include product content manager Choose "Yes", if you want links or files, added by the products content manager, to be included to the products description on exporting products.
Attribute option amount Choose the maximum number of options that will be exported. When a product has more than this amount of options, the Shopgate plugin will export these options as attributes. However, attributes are more complex to export. Therefore, the CSV file will contain more information than usual. The default value of 50 is a good threshold in this case.
Export product options as text field To export product options as text fields to the end of the text area, enter the option IDs here. You can find the option IDs in the "Product Options".
Export article filters as properties The selected product filters will be exported as properties. 

 

4.4 Importing Orders

Configure how orders are imported into your shop.

Shipping method Choose the shipping method applied to incoming Shopgate orders.
Shipping not blocked Set the status to be assigned on incoming Shopgate orders that are not blocked for shipping.
Shipping blocked Set the status to be assigned on incoming Shopgate orders that are blocked for shipping.
Shipped Select the status you set on orders that have been shipped. This is used to synchronize the shipping status of orders with Shopgate.
Cancelled Select the status you set on orders that have been cancelled. This is used to synchronize the cancellation status of orders with Shopgate.
Display names for payment methods Now you have a new option to display the payment methods in the names of your own choice. Simply specify a display name for each of your payment methods here using the formula "Code name"="your display name". Separate each payment formula with a semicolon. More details see How can I replace the code name of a payment on an order's detail page?

 

4.5 System Settings

These are a few debug settings that are usually only used on test and development systems or for compatibility reasons.

Shop system encoding Choose the encoding of your system. This is “ISO-8859-15” for Gambio versions before 2.1.1.2. Update: For Gambio versions v2.1.1.2 and higher, please use "UTF-8".
Shopgate server Choose between the “Live” or the “Playground” Shopgate servers for API communication. Alternatively you can provide a “Custom” Shopgate API URL.
Custom Shopgate server URL If you chose “Custom” in the dropdown menu box above, provide a custom URL to the Shopgate API here.

 

5. Adjusting codes for earlier Gambio versions

In order for the Shopgate plugin to work in your Gambio system, a few lines of codes need to be added to 9 files in your Gambio backend. How to modify codes in my shopping cart system?

Please modify all files listed below. Copy the marked codes, and paste them at the corresponding lines in your file. Line numbers in the following code snippets, however, refer to an "unmodified" version of files. If you already modified your files, the line numbers may vary. Only the highlighted parts need to be added into the files.

The paths are relative to your shop’s base folder. E.g. if your Gambio has been installed at /public_html/catalog/, then the path of includes/filenames.php refers to /public_html/catalog/includes/filename.php.

Also, keep in mind that the default folder name admin is used below. If you have renamed your admin folder, please locate the files in that directory.

 

Click on your Gambio version to see instructions:

5.1 Versions 2.0.6 and earlier

----------------------------------- part 1 -----------------------------------

  • Open the file admin/includes/column_left.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
echo ('<div class="leftmenu_head" style="background-image:url(images/gm_icons/statistik.png)">'.BOX_HEADING_STATISTICS.'</div>');
echo ('<div class="leftmenu_collapse leftmenu_collapse_opened"> </div>');
echo ('<ul class="leftmenu_box" id="BOX_HEADING_STATISTICS">');
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['gm_counter'] == '1')) echo '<li class="leftmenu_body_item"><a class="fav_drag_item" id="BOX_GM_COUNTER" href="' . xtc_href_link(FILENAME_GM_COUNTER, '', 'NONSSL') . '">' . BOX_GM_COUNTER . '</a></li>';
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['stats_products_viewed'] == '1')) echo '<li class="leftmenu_body_item"><a class="fav_drag_item" id="BOX_PRODUCTS_VIEWED" href="' . xtc_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '">' . BOX_PRODUCTS_VIEWED . '</a></li>';
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['stats_campaigns'] == '1')) echo '<li class="leftmenu_body_item"><a class="fav_drag_item" id="BOX_CAMPAIGNS_REPORT" href="' . xtc_href_link(FILENAME_CAMPAIGNS_REPORT, '', 'NONSSL') . '">' . BOX_CAMPAIGNS_REPORT . '</a></li>';
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['stats_customers'] == '1')) echo '<li class="leftmenu_body_item"><a class="fav_drag_item" id="BOX_STATS_CUSTOMERS" href="' . xtc_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '">' . BOX_STATS_CUSTOMERS . '</a></li>';
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['stats_sales_report'] == '1')) echo '<li class="leftmenu_body_item"><a class="fav_drag_item" id="BOX_SALES_REPORT" href="' . xtc_href_link(FILENAME_SALES_REPORT, '', 'NONSSL') . '">' . BOX_SALES_REPORT . '</a></li>';
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['stats_products_purchased'] == '1')) echo '<li class="leftmenu_body_item"><a class="fav_drag_item" id="BOX_PRODUCTS_PURCHASED" href="' . xtc_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '">' . BOX_PRODUCTS_PURCHASED . '</a></li>';
echo ('</ul>');

/******** SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/admin/includes/column_left.php';
/******** SHOPGATE **********/

echo ('<div class="leftmenu_head" style="background-image:url(images/gm_icons/module.png)">'.BOX_HEADING_XTBOOSTER.'</div>');
echo ('<div class="leftmenu_collapse leftmenu_collapse_opened"> </div>');
echo ('<ul class="leftmenu_box" id="BOX_HEADING_XTBOOSTER">');
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['xtbooster'] == '1')) echo '<li class="leftmenu_body_item"><a id="BOX_XTBOOSTER_LISTAUCTIONS" href="' . xtc_href_link(FILENAME_XTBOOSTER."?xtb_module=list", '', 'NONSSL') . '" class="fav_drag_item">'.BOX_XTBOOSTER_LISTAUCTIONS.'</a></li>';
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['xtbooster'] == '1')) echo '<li class="leftmenu_body_item"><a id="BOX_XTBOOSTER_ADDAUCTIONS" href="' . xtc_href_link(FILENAME_XTBOOSTER."?xtb_module=add", '', 'NONSSL') . '" class="fav_drag_item">'.BOX_XTBOOSTER_ADDAUCTIONS.'</a></li>';
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['gm_ebay'] == '1')) echo '<li class="leftmenu_body_item"><a class="fav_drag_item" id="BOX_GM_EBAY" href="' . xtc_href_link(FILENAME_GM_EBAY, '', 'NONSSL') . '">' . BOX_GM_EBAY . '</a></li>';
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['xtbooster'] == '1')) echo '<li class="leftmenu_body_item"><a id="BOX_XTBOOSTER_CONFIG" href="' . xtc_href_link(FILENAME_XTBOOSTER."?xtb_module=conf", '', 'NONSSL') . '" class="fav_drag_item">'.BOX_XTBOOSTER_CONFIG.'</a></li>';
echo ('</ul>');
  • Save the file.

----------------------------------- part 2 -----------------------------------

  • Open the file admin/includes/application_top.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
define('FILENAME_XTBOOSTER','xtbooster.php');
define('FILENAME_GM_JANOLAW','gm_janolaw.php');
define('FILENAME_PROPERTIES','properties.php');

/******** SHOPGATE **********/
define('FILENAME_SHOPGATE', 'shopgate.php');
define("TABLE_SHOPGATE_ORDERS", "orders_shopgate_order");
/******** SHOPGATE **********/

// define the database table names used in the project
define('TABLE_ADDRESS_BOOK', 'address_book');
define('TABLE_ADDRESS_FORMAT', 'address_format');
define('TABLE_ADMIN_ACCESS', 'admin_access');
  • Save the file

----------------------------------- part 3 -----------------------------------

  • Open the file admin/includes/functions/general.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
 if(!$canceled) {
xtc_db_query("delete from ".TABLE_ORDERS. " where orders_id = '".xtc_db_input($order_id)."'");
xtc_db_query("delete from ".TABLE_ORDERS_PRODUCTS. " where orders_id = '".xtc_db_input($order_id)."'");
xtc_db_query("delete from ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES. " where orders_id = '".xtc_db_input($order_id)."'");
xtc_db_query("delete from ".TABLE_ORDERS_STATUS_HISTORY. " where orders_id = '".xtc_db_input($order_id)."'");
xtc_db_query("delete from ".TABLE_ORDERS_TOTAL. " where orders_id = '".xtc_db_input($order_id)."'");
/******** SHOPGATE **********/
xtc_db_query("delete from ".TABLE_SHOPGATE_ORDERS. " where orders_id = '".xtc_db_input($order_id)."'");
/******** SHOPGATE **********/

// BOF GM_MOD GX-Customizer:
require_once('../gm/modules/gm_gprint_admin_general.php');
}
  • Save the file

----------------------------------- part 4 -----------------------------------

  • Open the file admin/orders.php
  • Copy the marked codes below, and past them at the corresponding position in your file.
case 'gm_multi_status':

// [...]

if ($order_updated) {
/******** SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/admin/orders.php';
setShopgateOrderlistStatus($_POST['gm_multi_status'], $gm_status);
/******** SHOPGATE **********/
$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
} else {
$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
}

case 'update_order' :

// [...]

if ($order_updated) {
/******** SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/admin/orders.php';
setShopgateOrderStatus($oID, $status);
/******** SHOPGATE **********/
$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
} else {
$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
}
  • Save the file

----------------------------------- part 5 -----------------------------------

  • Open the file includes/database_tables.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
 define('TABLE_CUSTOMERS_WISHLIST', 'customers_wishlist');
define('TABLE_CUSTOMERS_WISHLIST_ATTRIBUTES', 'customers_wishlist_attributes');

/******** SHOPGATE **********/
define("TABLE_SHOPGATE_ORDERS", "orders_shopgate_order");
/******** SHOPGATE **********/

define('TABLE_PAYPAL', 'paypal');

// BOF GM_MOD
define('GM_TABLE_GM_GMOTION', 'gm_gmotion');
define('GM_TABLE_GM_GMOTION_PRODUCTS', 'gm_gmotion_products');
// EOF GM_MOD
  • Save the file

----------------------------------- part 6 -----------------------------------

  • Open the file lang/german/admin/german.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
define('BOX_XTBOOSTER_ADDAUCTIONS','eBay Auktionen erstellen');
define('BOX_XTBOOSTER_CONFIG','xt:booster Konfiguration');
define('BOX_GM_JANOLAW','janolaw AGB Hosting');
define('BOX_PROPERTIES','Artikeleigenschaften');

/******* SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/lang/german/admin/german.php';
/******* SHOPGATE **********/

/* BOF YATEGO */
define('BOX_YATEGO','Yatego');
/* EOF YATEGO */
  • Save the file

----------------------------------- part 7 -----------------------------------

  • Open the file includes/header.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
?>
<?php
/******** SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/includes/header.php';
/******** SHOPGATE **********/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" <?php echo HTML_PARAMS; ?>>
<head>
<?php
if(gm_get_env_info('TEMPLATE_VERSION') < FIRST_GX2_TEMPLATE_VERSION)
{
echo '<meta http-equiv="X-UA-Compatible" content="IE=7" />';
}
/******** SHOPGATE **********/
echo $shopgateJsHeader;
/******** SHOPGATE **********/
  • Save the file

----------------------------------- part 8 -----------------------------------

  • Open the file system/views/product_info/ProductInfoContentView.inc.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
/******** SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/includes/header.php';
/******** SHOPGATE **********/

// include needed functions
require_once (DIR_FS_INC.'xtc_get_download.inc.php');
require_once (DIR_FS_INC.'xtc_delete_file.inc.php');
require_once (DIR_FS_INC.'xtc_get_all_get_params.inc.php');
require_once (DIR_FS_INC.'xtc_date_long.inc.php');
require_once (DIR_FS_INC.'xtc_draw_hidden_field.inc.php');
require_once (DIR_FS_INC.'xtc_image_button.inc.php');
require_once (DIR_FS_INC.'xtc_draw_form.inc.php');
require_once (DIR_FS_INC.'xtc_draw_input_field.inc.php');
require_once (DIR_FS_INC.'xtc_image_submit.inc.php');
  • Save the file.

----------------------------------- part 9 (optional) -----------------------------------

If you have activated the SEO Boost in Gambio, please also adjust this code below:

  • Open the file includes/application_top.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
// auto activate and expire banners
xtc_activate_banners();
xtc_expire_banners();
xtc_expire_specials();

/******** SHOPGATE **********/
include_once(DIR_FS_CATALOG.'shopgate/gambiogx/includes/application_top.php');
/******** SHOPGATE **********/

if(xtc_not_null($_GET['gm_boosted_content']))
{
$boosted_name = xtc_db_prepare_input($_GET['gm_boosted_content']);
  • Save the file.

 

5.2 Versions 2.0.7 and later

----------------------------------- part 1 -----------------------------------

  • Open the file admin/orders.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
 if ($order_updated) {
/******** SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/admin/orders.php';
setShopgateOrderlistStatus($_POST['gm_multi_status'], $gm_status);
/******** SHOPGATE **********/
$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
} else {
$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
}
 if ($order_updated) {
/******** SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/admin/orders.php';
setShopgateOrderStatus($oID, $status);
/******** SHOPGATE **********/
$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
} else {
$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
}
  • Save the file.

----------------------------------- part 2 -----------------------------------

  • Open the file admin/includes/application_top.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
define('FILENAME_BLACKLIST', 'blacklist.php');
define('FILENAME_PRODUCTS_VPE','products_vpe.php');
define('FILENAME_CAMPAIGNS_REPORT','stats_campaigns.php');
define('FILENAME_XSELL_GROUPS','cross_sell_groups.php');
define('FILENAME_XTBOOSTER','xtbooster.php');
define('FILENAME_GM_JANOLAW','gm_janolaw.php');
define('FILENAME_PROPERTIES','properties.php');
define('FILENAME_GM_INVOICING','gm_invoicing.php');
define('FILENAME_EKOMI','ekomi.php');

/******** SHOPGATE **********/
define('FILENAME_SHOPGATE', 'shopgate.php');
define("TABLE_SHOPGATE_ORDERS", "orders_shopgate_order");
/******** SHOPGATE **********/

// define the database table names used in the project
define('TABLE_ADDRESS_BOOK', 'address_book');
define('TABLE_ADDRESS_FORMAT', 'address_format');
  • Save the file

----------------------------------- part 3 -----------------------------------

  • Open the file admin/includes/functions/general.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
 if(!$canceled) {
xtc_db_query("delete from ".TABLE_ORDERS. " where orders_id = '".xtc_db_input($order_id)."'");
xtc_db_query("delete from ".TABLE_ORDERS_PRODUCTS. " where orders_id = '".xtc_db_input($order_id)."'");
xtc_db_query("delete from ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES. " where orders_id = '".xtc_db_input($order_id)."'");
xtc_db_query("delete from ".TABLE_ORDERS_STATUS_HISTORY. " where orders_id = '".xtc_db_input($order_id)."'");
xtc_db_query("delete from ".TABLE_ORDERS_TOTAL. " where orders_id = '".xtc_db_input($order_id)."'");
/******** SHOPGATE **********/
xtc_db_query("delete from ".TABLE_SHOPGATE_ORDERS. " where orders_id = '".xtc_db_input($order_id)."'");
/******** SHOPGATE **********/

// BOF GM_MOD GX-Customizer:
require_once('../gm/modules/gm_gprint_admin_general.php');
}
  • Save the file

----------------------------------- part 4 -----------------------------------

  • Open the file includes/database_tables.php
  • Copy the marked codes below, and past them at the corresponding position in your file.
  define('TABLE_CUSTOMERS_WISHLIST', 'customers_wishlist');
define('TABLE_CUSTOMERS_WISHLIST_ATTRIBUTES', 'customers_wishlist_attributes');

/******** SHOPGATE **********/
define("TABLE_SHOPGATE_ORDERS", "orders_shopgate_order");
/******** SHOPGATE **********/

define('TABLE_PAYPAL', 'paypal');

// BOF GM_MOD
define('GM_TABLE_GM_GMOTION', 'gm_gmotion');
define('GM_TABLE_GM_GMOTION_PRODUCTS', 'gm_gmotion_products');
// EOF GM_MOD
  • Save the file

----------------------------------- part 5 -----------------------------------

  • Open the file includes/filenames.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
define('FILENAME_ERROR_HANDLER', 'error_handler.php');
define('FILENAME_CONTENT', 'shop_content.php');
define('FILENAME_BANNER', 'banners.php');

define('FILENAME_PAYPAL_CHECKOUT', 'paypal_checkout.php');

/******** SHOPGATE **********/
define('FILENAME_SHOPGATE', 'shopgate.php');
/******** SHOPGATE **********/
?>
  • Save the file

----------------------------------- part 6 -----------------------------------

  • Open the file lang/english/admin/english.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
define('BOX_HEADING_XTBOOSTER','eBay');
define('BOX_XTBOOSTER_LISTAUCTIONS','List eBay Auctions');
define('BOX_XTBOOSTER_ADDAUCTIONS','Add eBay Auctions');
define('BOX_XTBOOSTER_CONFIG','xt:booster Configuration');
define('BOX_GM_JANOLAW','janolaw AGB Hosting');
/******* SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/lang/english/admin/english.php';
/******* SHOPGATE **********/

/* BOF YATEGO */
define('BOX_YATEGO','Yatego');
/* EOF YATEGO */
  • Save the file

----------------------------------- part 7 -----------------------------------

  • Open the file lang/german/admin/german.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
define('BOX_XTBOOSTER_ADDAUCTIONS','eBay Auktionen erstellen');
define('BOX_XTBOOSTER_CONFIG','xt:booster Konfiguration');
define('BOX_GM_JANOLAW','janolaw AGB Hosting');
define('BOX_PROPERTIES','Artikeleigenschaften');

/******* SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/lang/german/admin/german.php';
/******* SHOPGATE **********/

/* BOF YATEGO */
define('BOX_YATEGO','Yatego');
/* EOF YATEGO */
  • Save the file

----------------------------------- part 8 -----------------------------------

  • Open the file includes/header.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
<?php
/*
[...]
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
?>
<?php
/******* SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/includes/header.php';
/******* SHOPGATE **********/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" <?php echo HTML_PARAMS; ?>>
<head>
<?php

if(gm_get_env_info('TEMPLATE_VERSION') < FIRST_GX2_TEMPLATE_VERSION)
{
echo '<meta http-equiv="X-UA-Compatible" content="IE=7" />';
}
else
{
echo '<meta http-equiv="X-UA-Compatible" content="IE=edge" />';
}
/******** SHOPGATE **********/
echo $shopgateJsHeader;
/******** SHOPGATE **********/
  • Save the file

----------------------------------- part 9 -----------------------------------

  • Open the file system/views/product_info/ProductInfoContentView.inc.php
  • Copy the marked codes below, and paste them at the corresponding position in your file.
  Released under the GNU General Public License
---------------------------------------------------------------------------------------*/

/******** SHOPGATE **********/
include_once DIR_FS_CATALOG.'/shopgate/gambiogx/includes/header.php';
/******** SHOPGATE **********/

// include needed functions
require_once (DIR_FS_INC.'xtc_get_download.inc.php');
require_once (DIR_FS_INC.'xtc_delete_file.inc.php');
require_once (DIR_FS_INC.'xtc_get_all_get_params.inc.php');
require_once (DIR_FS_INC.'xtc_date_long.inc.php');
require_once (DIR_FS_INC.'xtc_draw_hidden_field.inc.php');
require_once (DIR_FS_INC.'xtc_image_button.inc.php');
require_once (DIR_FS_INC.'xtc_draw_form.inc.php');
require_once (DIR_FS_INC.'xtc_draw_input_field.inc.php');
require_once (DIR_FS_INC.'xtc_image_submit.inc.php');
  • Save the file.

 

6. Frequently Asked Questions (FAQ)

6.1 Why are my products not up-to-date?

Follow the step-by-step guide to pinpoint any potential issues.

Step 1. Recently upgraded Gambio to v2.1.1.2 or higher?

There has been a change in Gambio's product processing. If you have upgraded your Gambio to version v2.1.1.2 or higher, please follow Chapter 3 to update your Shopgate plugin.

In addition, follow Chapter 4.4 to change your system encoding to "UTF-8".

Step 2. Is the product import running?

The most common reason for outdated products is that the product import has been paused due to errors. To see if an error occurred, read Checking for errors in product import history

Step 3. Received error message "cannot open file"?

Check if files are getting "write permissions".

File permissions could change after system updates or changes. To check if your files are still getting the necessary permissions, follow chapter 1.2.

Update file directory for the plugin connection.

If the file permissions are not the issue, it's possible that the directory of the file has been changed after an update or server change. To update the file directory, follows the steps below:

  1. Follow Chapter 1.3 to open the Shopgate settings page in Gambio. Your settings should have been configured completely. Leave this page open.
  2. On your FTP server go to "../shopgate/shopgate_library", backup the folder config, then delete it from your shopgate library.
  3. Now go back to Shopgate settings page (do NOT change anything) and click save. This will create a new Config folder in the shopgate library with the updated file directory.

Now the connection has been established again with the correct file directory.

Step 4. Have you tried to update your Shopgate plugin?

If issue still exists, follow Chapter 3 to update your existing Shopgate plugin.

Step 5. Still not working?

Tried everything here but your products are still not updated? Contact Shopgate at support@shopgate.com

In your email, please state your shop number (Where can I find my shop number?), the troubleshooting steps you have already taken, and provide as much relevant info as possible.

 

6.2 How can I replace the code name of a payment on an order's detail page?

On an order's detail page of your mobile shop, a code name is shown for each payment method. For example, "AUTHN_CC" is shown if a customer has paid with a credit card via Authorize.net, and "COD" is shown if a customer selected "cash on delivery".

If you would prefer to display different names for your payment methods, you can now use the payment mapping feature in your Gambio admin. To do so, follow the steps here.

  1. In your Gambio admin, find the Shopgate entry on the left and click Settings.
  2. In the section Importing orders, find Display names for payment methods.
  3. To map your display names, enter "Code name"="your display name" and separate each payment with a semicolon. For example, enter
    AUTHN_CC=Credit card via Authorize;COD=Cash on delivery

Use the table below to find the code names of your payments.

Code name Description Code name Description
ACCRD_INS Installment via Accarda PAYONE_IDL iDEAL via PAYONE
ACCRD_INV Invoice via Accarda PAYONE_INV Invoice via PAYONE
AUTHN_CC Credit card via Authorize.net PAYONE_KLV Klarna invoice via PAYONE
BARZAHLEN Pay in store via Barzahlen PAYONE_PP PayPal via PAYONE
BILLSAFE Invoice via Billsafe PAYONE_PRP Prepayment via PAYONE
BRAINTR_CC Credit card via Braintree PAYONE_SUE SOFORT Überweisung via PAYONE
CHASE_CC Credit card via Chase Paymentech PAYPAL PAYPAL
CMPTOP_CC Credit card via Computop PAYU PayU
CMPTOP_DBT Direct debit via Computop PP_WSPP_CC Credit card via PayPal Website Payments Pro
CMPTOP_PP PayPal via Computop PPAL_PLUS PayPal Plus
COD Cash on Delivery PREPAY Prepayment
COLL_STORE Collection at store REALEX_CC Credit card via Realex
CONCAR_CC Credit card via ConCardis (DirektLink) SAGEPAY_CC Credit card via SagePay
CYBRSRC_CC Credit card via CyberSource SAGEPAY_PP PAYPAL via SagePay
DEBIT Direct debit SHOPGATE Shopgate payments
DT_CC Credit card via DataTrans SIX_CC Credit card via SIX Saferpay (External)
DTCASH_CC Credit card via DataCash SIX_IDEAL iDEAL via SIX Saferpay
EWAY_CC Credit card via eWAY SIX_PP PayPal via SIX Saferpay
FRSTDAT_CC Credit card via FirstData US SKRILL_CC Credit card via Skrill (External)
HDLPAY_CC Credit card via HeidelPay SKRILL_DBT Direct debit via Skrill
HDLPAY_SUE HeidelPay (SOFORT Überweisung) SKRILL_IDL iDEAL via Skrill
HIPAY Credit card via HiPay (exteral) SKRILL_SUE SOFORT Überweisung via Skrill
INVOICE INVOICE (Own Settlement) SPONE_DBT Direct debit via SEPAone
KLARNA_INV Invoice via Klarna STRIPE_CC Credit card via Stripe
MASTPAY_CC Credit card via Masterpayment SUE SOFORT Überweisung
MASTPAY_PP PAYPAL via Masterpayment TELECSH_CC Telecash
MASTPAY_SUE Masterpayment (SOFORT Überweisung) TRNSFST_CC Credit card via TransFirst
MSTPAY_INV Invoice via Masterpayment UPAID_MCM MasterPass
MWS Amazon Payments (Own - APA) USAEPAY_CC Credit card via USA ePay
OGONE_CC Credit card via Ogone WCARD_DBT Direct debit (External) via Wirecard (Checkout Page)
PAY4ONE_CC Credit card via Pay4one WCARD_INV Invoice via Wirecard (Checkout Page)
PAYJUNC_CC Credit card via PayJunction WCARD_PP PayPal via Wirecard (Checkout Page)
PAYMRW_DBT Direct debit via Paymorrow WCARD_SUE SOFORT Überweisung via Wirecard (Checkout Page)
PAYMRW_INV Invoice via Paymorrow WCARDS_CC Credit card (External) via Wirecard (Checkout Seamless)
PAYOL_INS Installment via Payolution WCARDS_DBT Direct debit (External) via Wirecard (Checkout Seamless)
PAYOL_INV Invoice via Payolution WCARDS_PP PayPal via Wirecard (Checkout Seamless)
PAYONE_CC Credit card via PAYONE WCARDS_SUE SOFORT Überweisung via Wirecard (Checkout Seamless)
PAYONE_DBT Direct debit via PAYONE WIRECRD_CC Credit card (External) via Wirecard (Checkout Page)
PAYONE_GP Giropay via PAYONE WORLDLINE Credit card via Worldline (External)

Comments