DropShip Commerce Connector for Magento User Manual
Contents
1. The product integration supports many useful features to help get product data into your Magento catalog e Flexible job scheduling Flexible Image Import Mapping e Support for loading products to multiple Magento websites e Category mapping for products from DropShip categories to Magento categories Flexible data mapping for product data between DropShip platform and Magento Inventory Integration The DropShip Commerce Connector for Magento also provides product inventory integration between the DropShip platform and your Magento store This integration can be scheduled to run regularly from every 5 minutes to once per week or in between and update your product inventory levels and pricing data in your Magento store Purchase Order PO Ordering Integration The heart of the DropShip Commerce Connector for Magento is the purchase order PO integration The connector allows your Magento store to automatically split orders between order items fulfilled through the DropShip platform and those which are fulfilled in house The connector then generates PO s for all products which will be fulfilled from the DropShip platform The PO records are transmitted to your suppliers through the DropShip platform and order status and tracking information is automatically routed back to Magento and thus to your customers Dropship Commerce Magento Extension User Manual v1 0 8 1 5 010010010010010010010010010010010 01001001001001001002. Job ID Simple enable disable configuration setting Setting this to disabled will completely disable the inventory integration from being run according to the configured schedule or manually from the Run Feeds page Setting this to enabled will allow the integration to run on the configured schedule This setting allows you to configure the frequency at which the Inventory feed will automatically run when the Magento cron is enabled The Inventory Feed will be retrieved from DropShip Commerce and processed into Magento at the batch processing limit until completion This is the ID of the job created in the Inventory Integration section and will be used to retrieve the inventory feed file from the DropShip platform for processing into Magento Cron Job Parameters Batch Job Processing Limit This is the number of records that will be processed into Magento every time the Process Inventory job is run This process runs independently of the Feed Schedule Frequency set in configuration Dropship Commerce Magento Extension User Manual v1 0 8 1 30 1010010010010010010010010010010010 010010010010010010010010010010010 agile ecommerce d v loprrnierit storeFront Consulting Inventory Integration Feed Scheduling The inventory feed has several options for scheduling It can be run every 5 minutes once per hour once per day or once per week After the first run of the product feed only changes will be retrieved for subsequ
3. Type Select EDSS for the Platform Select 1 0 for the Platform Version Select File Tab as the Method Click Next 2 Settings 3 Schedule Dropship Commerce Magento Extension User Manual v1 0 8 1 19 010010010010010010010010010010010 010010010010010010010010010010010 1ANANNANNANNAN NA ild ecommerce development storeFront Consulting 3 Step 2 Settings Source Data Pick the source of products you wish to pull into Magento You can choose a single supplier all suppliers or a single assortment Check the Only include changes since last successful run box Select Download as the Destination Type Add an email address to receive failure notifications Click Next 4 Format 2 Settings Export Source source Oats Aus s Only include changes since the last successful run Export Destination Destination Type Download Failure Notifications emai dress TT 4 Step 4 Schedule Click I m Done Dropship Commerce Magento Extension User Manual v1 0 8 1 20 010010010010010010010010010010010 010010010010010010010010010010010 AC OAD OAD OAD OAD NA agile ecommerce development gt storeFront Consulting Inventory Integration A job needs to be created in the DropShip Commerce platform to allow for Magento to retrieve Inventory information on products in the DropShip Commerce platform 1 Click the Add Job Button 2 Step 1 Format Type in Invento
4. as explicitly setting the image dimensions Unless the padding option is set to yes the image will maintain its aspect ratio while satisfying any maximum dimensions set by configuration This yes no setting will be passed to the DropShip platform for processing product images during retrieval If set to yes padding will be added to the image to make up the dimensions specified in Max X and Max Y The padding will be transparent if the original image format supports it otherwise it will be white This yes no setting will be used to set whether the Exclude box will be checked for the primary image If set to yes the primary image will not be included as an additional image This yes no setting controls whether the primary image from the DropShip platform will be used as the base image in Magento This yes no setting controls whether the primary image from the Dropship Commerce Magento Extension User Manual v1 0 8 1 34 010010010010010010010010010010010 010010010010010010010010010010010 f agile ecommerce d v loprn rit 1 storeFront Consulting DropShip platform will be used as the small image in Magento Import Thumbnail This yes no setting controls whether the primary image from the DropShip platform will be used as the thumbnail in Magento Websites Product Websites This multi select field allows you to select 1 or more websites that products will be assigned to in Magento when processing the product feed from the
5. end of the Data on Demand URL Tracking Out Job ID j50eed7eb8228e461613200 GLOBAL Enter the Tracking Info Out Data on Demand Job ID obtained from the Dropship Commerce platform You can obtain this Job ID from the end of the Data on Demand URL Order Integration Configuration Setting Details General Dropship Commerce Magento Extension User Manual v1 0 8 1 26 510010010010010010010010010010010 01 1001001001001001001 OO10010010010 Order Integration f agile ecommerce d v loprn rit 1 storeFront Consulting Simple enable disable configuration setting Setting this to disabled will stop Purchase Orders from being sent to DropShip Commerce and it will disable status updates Set it to enabled to allow for orders and order updates to be synchronized between DropShip Commerce and Magento SFTP Credentials Server Address Username Password Data On Demand Orders Job ID Order Status Out Job ID Tracking Out Job ID This is the address of the DropShip Commerce ftp server where Purchase Orders will be sent from Magento to DropShip Commerce for processing This needs to be set to ftp dropship com This is the username for the ftp account received from DropShip Commerce Contact DropShip Commerce support if you do not already have this information This is the password for the ftp account received from DropShip Commerce Contact DropShip Commerce support if you do not already
6. product groups from Dropship to Magento configurable products e 43533719 44765145 58888558 Improvements and bug fixes in mapping of images during product feed e Bugs Fixed in Release e 59067338 Fix bug in case where DB connections were timing out when DS API calls took longer than 15 minutes Dropship Commerce Magento Extension User Manual v1 0 8 1 45 1010010010010010010010010010010010 010010010010010010010010010010010 ANA O1 Caile ecommerce d v lopment storeFront Consulting Release 1 0 3 Release Date 2013 03 28 Stability Beta Compatibility 1 5 1 6 1 6 1 1 6 2 0 1 7 1 9 1 0 1 9 2 0 1 10 1 11 1 11 1 1 12 Features Added in Release e Add support for Magento 1 9 1 1 Further enhance the product feed integration Fix bug with suppliers being created multiple times Dropship Commerce Magento Extension User Manual v1 0 8 1 46
7. 01001001001001001001001001001001 01001001001001001001001001001001 agile ecommerce d v lopment storeFront Consulting DropShip Commerce Connector for Magento User Manual Extension Version 1 0 8 1 Document Updated August 6 2014 DROPSHIP CO MM E RCE StoreFront Consulting Inc 9807 Old Court Rd Baltimore MD 21244 Dropship Commerce Magento Extension User Manual v1 0 8 1 1 010010010010010010010010010010010 010010010010010010010010010010010 4 34 n0 0 4 agil cormrrierce d v lopment storeFront Consulting Table of Contents VST NCW c Y aiaia 4 tele Tele ln A Inventory Integration nuce erre e tee eege exe eed eee dE deg 5 Purchase Order PO Ordering Integration 5 System Requirements ccccccccecccecccecsesseeeceeeececeaeseseecseceeeeseseeseeeesceceeeecessesaeeeseeeeeeeeseeaeanes 6 Installation Step by Step Instructions ssssssssss Hmmm 8 Configuration DropShip Platform see 12 Order Integration Purchase Orders ss 12 Order Integration Order Status sise 15 Order Integration Tracking Inf seen iesen termes Rande ReeSE EES gen 17 Product IntegratlODz eise oraret ena ge dee tante care est muet 19 Inventory Integrals rm 21 Da De D E ER E 23 Configuration Magento Extension ee reiten ugebuedenen dee 24 General Configuration EET Tp 24
8. 10010010010010 f agile ecotririerc d velopment lt 1 storeFront Consulting System Requirements Make sure your Magento instance meets the following system requirements which are necessary for Magento and the extension to run correctly Ata minimum the following software is required e Supported Operating Systems o Linux x86 x86 64 e Supported Web Servers o Apache 1 3 x o Apache 2 0 x o Apache 2 2 x e Supported Browsers o Microsoft Internet Explorer 7 and above o Mozilla Firefox 3 5 and above o Apple Safari 5 and above on Mac only o Google Chrome 7 and above o Adobe Flash browser plug in should be installed PHP Compatibility o 5213 o Required extensions PDO MySQL simplexml mcrypt hash GD DOM iconv curl SOAP if Web services API is to be used o Safe mode off o Memory limit no less than 256Mb preferably 512 MySQL o 4 1 20 or newer o InnoDB storage engine e SSL o If HTTPS is used to work in the admin SSL certificate should be valid Self signed SSL certificates are not supported Server hosting setup Dropship Commerce Magento Extension User Manual v1 0 8 1 6 010010010010010010010010010010010 010010010010010010010010010010010 TO EN AYN ON AYN OY AYO 4 agil l commerc d v lobment storeFront Consulting o Ability to run scheduled jobs crontab with PHP 5 o Ability to override options in htaccess files For more info on Magento system require
9. 10010010010010010010010 OA O40 04004902040n249 gid ecommerce d v lopimerit gt storeFront Consulting 4 Step 2 Settings Leave the defaults and add an email address for failure notifications Click Next 1 Format 2 Settings Import Source Source Type Failure Notifications Email Address 5 Step 3 Schedule Set the schedule to run once per year in January This is going to be triggered to run automatically when orders are sent over from Magento so we don t need it to run on its own schedule Click Save 4 Format 2 Settings 3 Schedule Run once 7 per year 7 on the 1st Hal January Ia C00 minutes past Bam Please Note that All Times Indicated are MST Dropship Commerce Magento Extension User Manual v1 0 8 1 14 M1 01 001001001001001001 0010010010010 2010010010010010010010010010010010 TOO TNA TAN 1 agil ecommerce d v lobment storeFront Consulting Order Integration Order Status A job needs to be created in the DropShip Commerce platform to allow Magento to retrieve the status of Purchase Orders from the DropShip Commerce platform 1 Click the Add Job Button 2 Step 1 Format Type in Order Status Out for the Job Title Select Order Status Out for Job Type Select EDSS for the Platform Select 1 0 for the Platform Version Select File Tab as the Method Click Next 2 Settings 3 Schedule Dropship Commerce Magento Extensi
10. DropShip platform System Parameters Product Import This is the number of records that will be processed into Magento per job Batch Limit run The Process Product Feed job will be started every 5 min following the successful completion of the Retrieve Product Feed as configured in the Feed Schedule settings and will continue to run every 5 until all records have been processed Product Integration Feed Scheduling The product feed can be scheduled to run any day of the week at a time of your choosing Every time the product feed is run a complete data set is retrieved for processing The product feed is completed in two steps retrieve and read the product feed into the database then process the records into Magento The product feed will be retrieved and loaded into the database at the configured day and time Once retrieved the product feed will be processed every 5 minutes continuously after retrieval until done in blocks of N records where N is the configuration parameter batch size Frequency Start Time Weekly Day of choice Time Chosen Dropship Commerce Magento Extension User Manual v1 0 8 1 35 010010010010010010010010010010010 010010010010010010010010010010010 f agile commerc d v lopment lt 1 storeFront Consulting Supplier Configuration The supplier configuration is located in the main navigation menu under DropShip Commerce gt Manage Suppliers and is where you will add your DropShi
11. Large Color Blue SH 123 L R Large Red Shirt Size name config_attributes configurable SH 123 CFG Shirt 123 size color d CFG added ta i product group to form configurable product sku product_group product_title sku attribute_name_1 attribute_value_1 attribute_name_2 attribute_value_2 type sku name simple SH 123 S B Small Blue Shirt Small Red simple SH 123 S R Small Red Shirt Small Red simple SH 123 L R Large Red Shirt Large Red Dropship Commerce Magento Extension User Manual v1 0 8 1 39 010010010010010010010010010010010 O1 1001001001001001001 OO10010010010 A f agile ecommerce development storeFront Consulting Processing Initial Product and Inventory Feeds Product and inventory feeds should be scheduled to run automatically based on specific requirements of the Magento store However feeds should be run manually at first to initially populate the Magento catalog and ensure the system is configured correctly Please follow this procedure to retrieve your initial product and inventory feeds 1 Retrieving the product feed from DropShip Commerce Navigate to the DropShip Commerce menu select Run Feeds and then click the Retrieve Product Feed button When you retrieve the product feed from DropShip Commerce it will transfer a file which contains all of the data for the products in your DropShip Commerce platform and read it into your Magento database Depending on the size o
12. NUE Shipping Methods w A es A agile ecommerce d velopment storeFront Consulting a Virtue Product Websites Main Website GLOBAL Google API Private Sales Website Payment Methods Payment Services Gif Cards Moneybookers gt SERVICES Select from the list of website codes on which to place products from the feed If left blank products will be duces in placed on all websites OAuth System Parameters A ADVANCED Admin Product Import Batch Limit GLOBAL D dc E ME Rs SRE e y tren in effect Please set this value to limit the number of Advanced products added to the Magento catalog in one cron Developer processing run Product Integration Configuration Settings Details General Product Integration Feed Schedule Day of Week Feed Schedule Time of Day Data On Demand Product Out Job ID Simple enable disable configuration setting Setting this to disabled will completely disable the product integration from being run according to the configured schedule or manually from the Run Feeds page Setting this to enabled will allow the integration to run on the configured schedule This dropdown allows you to set the day of the week the Product Integration will be run automatically This time setting allows you to set the time of day to run the Product Integration This is the ID of the job created in the Product Integration section and will be used to retrieve the product feed fi
13. Order Integration Configuration egene tege deene 25 Order Integration Scheduling E 27 Inventory Integration Configuration SEN geed deene 29 Inventory Integration Feed SCheduling 2 sssss nissan 31 Product Integration Configuration en ae EE Rep RDRENE HUP UE Ehud Cpu eine 32 Product Integration Feed Scheduling 35 S pplier Conmigu ratiON WE 36 Dropship Commerce Magento Extension User Manual v1 0 8 1 2 010010010010010010010010010010010 10100100100100100100100100100100101 16936 4 f agile ecommerce development 1 StoreFront Consulti ng Product Feed Configurable Product Mapping AAA 38 Product Attribute Mapping iine tere denne nr nene testet deed ee egen de 38 Cantig rable Product Mapping uiis iura ker DE BRE UU pDRuP LQa thc pb LER ER OPER In Me deeg Egeter 39 Simple Product Mapping Configurable children sseseeeeeceeeeeeeeeerreerrreeesrrrrirrsesrrrerre 39 Processing Initial Product and Inventory Feeds eeeeeeeseeereeereeerresreeerresrresrerrreerreere 40 Purchase Order PO Ordering Integration Manual Trogerng 42 Manually Sending Purchase Orders to DropShip Commerce 42 Manually Retrieving Order Status Tracking Information seeeeeeeeeeeeeeeeeeireeeerenrreeeeee 42 Extension Support amp Contact Information ssssssssssHH 43 Extension Support Provided by DropShip Commerce ss ssessseesertesttrrtrrrttrrtrnrrenrrenr renn 43 e 43 Dro
14. Tags Status Configuration System config xml local xmi and modules configuration files config xml CONFIG Layouts Layout building instructions LAYOUT_GENERAL_CACHE_TAG Blocks HTML output Page blocks HTML BLOCK_HTML Translations Translation files TRANSLATE Collections Data Collection data files COLLECTION DATA EAV types and attributes Entity types declaration cache EAV Web Services Configuration Web Services definition files api xml CONFIG_API Web Services Configuration Web Services definition files api2 xml CONFIG API2 Page Cache Full page caching FPC cen Additional Cache Management eRe UE eels Pregenerated product images files hist ee TER Themes JavaScript and CSS files combined to one file Magento ver 1 1202 Connect with the Magento Community Interface Locale English United States English v II Magento is a trademark of Magento Inc Copyright 2012 Magento Inc 8 Go to System gt Index Management and click Re Index Data for all indexes Magento Admin Panel Logged in as mmile Dashboard Sales Catalog Mobile Customers Promotions Newsletter CMS Reports System Get help for this page Index Management Seloct Ak Une All Select Visible Unselec Visible 0 tems selected Actions Reindex Data Ea submit Index Description Mode Status Update Required Updated At Action Product Attributes Index product attributes for layered navigation building Update on Save GENTES Mar 3 2012 92006
15. ain link for the job and copy the last part of the URL after the last Note the chain links in the shaded area and the highlighted part of the URL indicating the Data On Demand ID Data On Demand Url Dropship Commerce Magento Extension User Manual v1 0 8 1 23 010010010010010010010010010010010 010010010010010010010010010010010 2f agile ecommerce development NO NA A Configuration Magento Extension General Configuration storeFront Consulting Log into Magento admin and navigate to System gt Configuration and then to DropShip Commerce gt General If you do not see the DropShip Commerce section please refer back to the beginning of this document to install the extension On this screen enter the server address for your DropShip Commerce account login username and password Enter app dropship com in Server Address Enter your DropShip Commerce account username in Username Enter your DropShip Commerce account password in Password Click Save Config General Server Address Username Password app dropship com Enter Data On Demand Hostname storefrontconsulting Enter Data On Demand username Enter Data On Demand account password Dropship Commerce Magento Extension User Manual v1 0 8 1 GLOBAL GLOBAL GLOBAL 24 1010010010010010010010010010010010 010010010010010010010010010010010 4 58A np O1 f agile ecommerce d v lopme
16. am Reindex Data Product Prices Index product prices Update on Save GENTE May 3 2012 9 20 06 AM Reindex Data Catalog URL Rewrites Index product and categories URL rewrites Update on Save GRD May 3 2012 9 20 08 AM Reindex Data Product Flat Data Reorganize EAV product structure to flat structure Update on Save CP May 3 2012 9 20 12 AM Reindex Data j Category Flat Data Reorganize EAV category structure to flat structure Update on Save CRD May 3 2012 9 20 12 AM Reindex Data O Category Products Indexed category products association Update on Save GRD May 3 2012 9 20 12 am Reindex Data C Catalog Search Index Rebuild Catalog product fulltext search index Update on Save GENTE May 3 2012 9 20 13 am Reindex Data Stock Status Index Product Stock Status Update on Save CRD May 3 2012 9 20 05 am Reindex Data Tag Aggregation Data Rebuild Tag aggregation data Update on Save SD CHED May 3 2012 9 20 13 am Reindex Data Help Us Keep Magenta Healthy Report ll Bugs Magento ver 1 7 00 with the Interface Locale English United States English H A Magento is a trademark of Magento Inc Copyright 2012 Magento Inc Dropship Commerce Magento Extension User Manual v1 0 8 1 14 010010010010010010010010010010010 010010010010010010010010010010010 1 agile ecommerce d v lopment storeFront Consulting Configuration DropShip Platform The following configuration is required on the DropShip platform to prepare your DropShip Commerce ac
17. atus 1 Viewing the Logs If logging is enabled in your Magento configuration the extension logs can be found at lvar log dropshipcommerce log on your server Dropship Commerce Magento Extension User Manual v1 0 8 1 43 010010010010010010010010010010010 010010010010010010010010010010010 f agile ecotririerc d v lopment lt 1 storeFront Consulting Release Notes Release 1 0 8 1 Release Date 2014 08 06 Stability Stable Compatibility 1 5 1 6 1 6 1 1 6 2 0 1 7 1 8 1 10 1 11 1 11 1 1 12 1 13 e Fixed an issue where some attribute values were not being set properly e Improved scheduling process for processing product and inventory feeds Release 1 0 8 Release Date 2014 08 01 Stability Stable Compatibility 1 5 1 6 1 6 1 1 6 2 0 1 7 1 8 1 10 1 11 1 11 1 1 12 1 13 e Added option to pull product feed from the DropShip Commerce FTP server e Added additional logging and debug information to the logs Release 1 0 7 Release Date 2014 07 11 Stability Stable Compatibility 1 5 1 6 1 6 1 1 6 2 0 1 7 1 8 1 10 1 11 1 11 1 1 12 1 13 e Added support for multiples images on configurable products e Now storing user defined fields so that they can be mapped to Magento attributes via the product processing script Release 1 0 6 Release Date 2014 07 02 Stability Stable Compatibility 1 5 1 6 1 6 1 1 6 2 0 1 7 1 8 1 10 1 11 1 11 1 1 12 1 13 Improved support for conf
18. count to connect to your Magento instance with the Magento extension The jobs must be configured within DropShip Commerce so that the Magento extension can interact with it using the appropriate channels decided on by you the retailer Order Integration Purchase Orders A job needs to be created in the DropShip Commerce platform to allow for Magento to deliver Purchase Orders to DropShip Commerce and trigger them to be imported 1 Log into the DropShip Commerce platform at https app dropship com login html 2 Click Integration in the main navigation menu and then click Add Job OF Dropship Support POWERED BY d DROPSHIP Orders Vendors Integration Account Cart Oitems 0 00 QuickOrder Product Lists Products Manage History Alerts Spreadsheet Manager Integration Set Up View FTP Dropship Commerce Magento Extension User Manual v1 0 8 1 12 010010010010010010010010010010010 010010010010010010010010010010010 POA OAD OAD OAD OADM agile ecommerce d v lopment C storeFront Consulting 3 Step 1 Format Type in Orders In for the Job Title Select Order In for Job Type Select EDSS for the Platform Select 1 0 for the Platform Version Select File Tab as the Method Click Next 2 Settings Dropship Commerce Magento Extension User Manual v1 0 8 1 13 KR LK Ae ON DOW XA DU DONS TTYL I 010010010010010010010010010010010 90100100100
19. d Base Default 1 7 0 0 stable This is a Magento themes base Interface Frontend Default 1 7 0 0 stable Default intertace for Frontend Interface Install Default 1 7 0 0 stable Default interface for Install Lib Google Checkout 1 5 0 0 stable Google Checkout Library Lib Js Calendar 1 51 1 1 stable Javascnpt Calendar for Magento Lib Js Ext 17 0 0 stable Extjs Javascript Libraries for Magento 6 Now that file is uploaded click on the Return to Admin link on the top right corner of the page Dropship Commerce Magento Extension User Manual v1 0 8 1 10 1001001001001001001001001001001 010010010010010010010010010010010 agile ecommerce development storeFront Consulting 7 Go to System gt Cache Management and click Flush Magento Cache then when complete click Flush Cache Storage Magento Enterprise Dashboard talog Mobile Customers Promoti P p System One or more of the Cache Types are invalidated Page Cache Click here to go to Cache Management and refresh cache types Latest Message Important Security Update Zend Platform Vulnerability Read details You have 1 notice unread message s Go to messages inbox Cache Storage Management Flush Magento Cache Flush Cache Storage Select All Unselect All Select Visible Unselect Visible 0 items selected Actions Refresh v Submit Cache Type Description Associated
20. ent runs The inventory feed will be retrieved at scheduled interval and processed every 5 minutes continuously after retrieval until done in blocks of XXX records where XXX is the config parameter batch size Frequency Start Time Every 5 Minutes Every 5 Minutes Once Per Hour 20 minutes past the hour Once Per Day 2 20am in Time Zone configured Once Per Week 2 20am on Saturday in Time Zone Configured Dropship Commerce Magento Extension User Manual v1 0 8 1 31 010010010010010010010010010010010 010010010010010010010010010010010 CN EN CN EN M AM A agile ecommerce d v lopment lt 1 storeFront Consulting Product Integration Configuration Now navigate to DropShip Commerce gt Product Integration On this screen you will Enable Disable the Product Integration enter the Data on Demand Job ID to retrieve the product feed configure image handling and select the websites to import products into the Tax Class to set and the number of products to process into the catalog at a time Current Configuration Scope Product Integration Save Contig Save Config Default Config Hr Manage Stores Configuration Product Integration Enabled D GLOBAL Enable disable product integration GENERAL ry i Run Day Thursday GLOBAL Age ee Sect the day to run tw product repa Web To Run Time mA foTe IGLOBAL Product Out Job ID Primary Image Max X Primary I
21. extension supports mapping product groups from product data in the DropShip platform to Magento configurable products Product groups in the platform are identified by the product group attribute The following diagrams how data from the DropShip platform is mapped to product attributes configurable products and their corresponding simple product children in Magento Product Attribute Mapping attribute name 2 attribute_value_2 attribute_value_1 product_group product title sku i attribute name 1 H 123 Shirt 123 SH 123 S B Small Blue Shirt Size Small Color Blue H 123 Shirt 123 SH 123 SR Small Red Shirt Size Small Color Red H 123 Shirt 123 SH 123 L B Large Blue Shirt Size Large Color Blue SH 123 Shirt 123 SH 123 L R Large Red Shirt Sie Large Color Ka n wu Name convereted to lower case ta farm attribute code attribute code attribute_name values Size Small Large Blue Red Color Dropship Commerce Magento Extension User Manual v1 0 8 1 38 Me 10 001001001001001001001001001001 01001001001001001001001001001 agile ecommerce development storeFront Consulting Configurable Product Mapping product_group product title sku title attribute name 1 attribute value 1 attribute name 2 attribute_value_2 5 H 123 H 123 Shirt 123 SH 123 5 8 Small Blue Shirt Size Small Color Blue Shirt 123 SH 123 S R Small Red Shirt Size Small Color Red Shirt 123 SH 123 L B Large Blue Shirt Size
22. f the catalog it may take some time to transfer the file Processing the product feed into Magento Navigate to the DropShip Commerce menu select Run Feeds and then click the Process Product Feed button Batches of products will be imported into Magento based on the configured settings With the configuration settings you can control the number of products to import each time the job is run the website s the product will be sold in the tax class to be used the product image size to create whether to exclude the image from the additional images section and whether or not to add padding to the product image Retrieving the Inventory Feed Navigate to the DropShip Commerce menu select Run Feeds and then click the Retrieve Inventory Feed button The first time the inventory feed is retrieved the entire inventory file will be retrieved Every following feed will only contain the changes The file will be retrieved and read into the Magento database Dropship Commerce Magento Extension User Manual v1 0 8 1 40 010010010010010010010010010010010 010010010010010010010010010010010 4 884 8 60 11 11 agile ecommerce development storeFront Consulting 4 Processing the Inventory Feed Navigate to the DropShip Commerce menu select Run Feeds and then click the Process Inventory Feed button Once the file is retrieved from the DropShip platform and read into the database it can be processed into Magento based on the proce
23. have this information This is the ID of the job created in the Order Integration Purchase Orders section and will be triggered when Purchase Orders are sent to the DropShip Commerce ftp server This is the ID of the job created in the Order Integration Order Status section and will be run automatically every hour but can also be run manually This is the ID of the job created in the Order Integration Tracking Info section and will be run automatically every hour but can also be run manually Order Integration Scheduling Purchase Orders Sent to DropShip Commerce When orders are placed in Magento a Purchase Order is created Only Purchase Orders that have PO Status Created and Order Status Processing will be sent to the DropShip platform Dropship Commerce Magento Extension User Manual v1 0 8 1 27 010010010010010010010010010010010 010010010010010010010010010010010 f agile ecotririerc d v lopment lt 1 storeFront Consulting automatically Purchase Orders that meet the requirements are sent hourly at 10 minutes past the hour The Purchase Orders will be sent to DropShip Commerce via the FTP account configured above and the extension will trigger DropShip Commerce to import those orders as soon as they are uploaded to the FTP server Order Status POStatus Frequency Start Time Processing Created Hourly 10 minutes past the hour Order Status Tracking Retrieved From DropShip Commerce As Purcha
24. hip Commerce menu select Run Feeds and then click the Retrieve Latest PO Order Status button When Purchase Orders are sent to DropShip Commerce the Orders In job is triggered and the Purchase Orders are processed Once Purchase Orders are downloaded and accepted by Suppliers in DropShip Commerce the Order Status job can be run to update the PO with the Accept status Once Purchase Orders are shipped by the Supplier in the DropShip Commerce platform the shipping tracking information can be retrieved by processing the Order Status job once again Dropship Commerce Magento Extension User Manual v1 0 8 1 42 1010010010010010010010010010010010 010010010010010010010010010010010 f agile ecommerce d velopment storeFront Consulting Extension Support amp Contact Information Extension Support Provided by DropShip Commerce Email Support Hours 8am 5pm Mountain Time Email support dropship com Software License All of our software products are licensed for commercial use under the following license agreement Download View ExtensionLicense pdf References DropShip Commerce Platform Developer Documentation http developer dropship com retailer developer center http developer dropship com Troubleshooting Helps Stopping Feed Processing Run the following query on your MySQL database to stop the processing of any product or inventory data update dropship product set processing_st
25. igurable products Release 1 0 5 1 Dropship Commerce Magento Extension User Manual v1 0 8 1 44 010010010010010010010010010010010 010010010010010010010010010010010 f agile ecotririerc d v lopment lt 1 storeFront Consulting Release Date 2014 04 22 Version number 1 0 5 1 Stability Stable Compatibility 1 5 1 6 1 6 1 1 6 2 0 1 7 1 8 1 10 1 11 1 11 1 1 12 1 13 Removed all line breaks from Purchase Orders fields being sent to DropShip Commerce to ensure that the TAB delimited files are imported properly Release 1 0 5 Release Date 2013 12 27 Stability Stable Compatibility 1 5 1 6 1 6 1 1 6 2 0 1 7 1 8 1 10 1 11 1 11 1 1 12 1 13 Opened up the extension by removing all licensing and code protection The extension can now be distributed freely and its code can be manipulated locally Release 1 0 4 Release Date 2013 10 31 Stability Stable Compatibility 1 5 1 6 1 6 1 1 6 2 0 1 7 1 8 1 10 1 11 1 11 1 1 12 1 13 Fully implement new packaging licensing system Extension is now licensed through SFC Licenser tool and packaged by Jenkins builds Features Added in Release e Cleaned up code style and formatting e 58882156 Support multiple categories separated by on DS products in feed e 45316953 45235381 Minor fixes to text in menus and throughout Admin GUI e 43637797 Fixed issue with line item expected cost field mapping e 43533719 Implement support for mapping
26. is page Latest Message Important Security Update Zend Platform Vulnerability Read details My Account You have 1 notice unread message s Go to messages inbox Hait cations Dashboard Tools 4 I 7 4 Content Staging al Choose Store View All Store Views M Web Services A Design Lifetime Sales f ImpontBport SS 4 Orders Amounts Mana e en enc ge Currency 0 00 Lis da Transactional Emails PEN Es San Select Range Last 24 Hours M Average Orders Custom Variables 2 1 Permissions al 0 00 k Admin Actions Log al Mana e Em tion Key Last 5 Orders I s it d t Customer Items Grand Total L Magento Connes Phil Accept 2 156 04 Cache Manage SEH i n Package Extensions 1 Index Manager Last 5 Search Terms Manage Stores Search Term Results Number of Uses p ac med Order Statuses No records found Configuration Top 5 Search Terms Search Term Results Number of Uses 5 00 PM 8 00 PM 11 00 PM 2 00 AM 5 00 AM 8 00 AM 11 00 AM 2 00 PM No records found Revenue Tax Shipping Quantity 0 00 0 00 0 00 Dropship Commerce Magento Extension User Manual v1 0 8 1 8 010010010010010010010010010010010 O10010010010010010010010010010010 1001 agile ecommierc d velopment storeFront Consulting 4 You ll be prompted to log in to the Magneto Connect Manager Use the same username password as you use to login to the regular Magento Admin page Only users with an admin role can access the Mage
27. le from the DropShip platform for processing into Magento Product Field Mapping Map DropShip Long This yes no configuration setting allows you to import the Dropship Commerce Magento Extension User Manual v1 0 8 1 33 Description to Magento Short Description Tax Class Product Images Primary Image Max X Primary Image Max Y Primary Image Padding Primary Image Exclude Setting Import Base Image Import Small Image 010010010010010010010010010010010 010010010010010010010010010010010 f agile ecommerce d v loprn rit 1 storeFront Consulting long_description on the DropShip platform into the short_description field in Magento if your products do not have a short description This dropdown allows you to set the tax class that will be used in Magento for the imported products This setting will be passed to the DropShip platform for processing product images during retrieval The Max X setting controls the maximum width of the image to be retrieved This is only a maximum and not the same as explicitly setting the image dimensions Unless the padding option is set to yes the image will maintain its aspect ratio while satisfying any maximum dimensions set by configuration This setting will be passed to the DropShip platform for processing product images during retrieval The Max Y setting controls the maximum height of the image to be retrieved This is only a maximum and not the same
28. mage Max Y Primary Image Padding Primary Image Exclude Setting Import Base Image Import Small Image Import Thumbnail The current system time is 14 31 16 Select the time of day to run the product integration Please reference the current system time j511bd24eaed18186631906 Enter the Product Out Data on Demand Job ID obtained from the DropShip Commerce platform You can obtain this Job ID from the end of the Data on Demand URL 640 Please enter the Max X param in pixels 480 Please enter the Max Y param in pixels No Should DropShip platform pad the image with transparent or white background Yes n Should this image be flagged for Exclude when added to Magento product Yes n Should product image attribute be filed with primary image from DropShip platform Yes D Should product small_image attribute be filed with primary image from DropShip platform Yes D Should product thumbnail attribute be filed with primary image from DropShip platform Data On Demand A GLOBAL Map DropShip Long Description Yes D GLOBAL to Magento Short Description Tax Class Taxable Goods GLOBAL GLOBAL GLOBAL GLOBAL GLOBAL GLOBAL GLOBAL GLOBAL Dropship Commerce Magento Extension User Manual v1 0 8 1 32 010010010010010010010010010010010 010010010010010010010010010010010 Bm IA
29. ments visit http www magentocommerce com system requirements Dropship Commerce Magento Extension User Manual v1 0 8 1 7 010010010010010010010010010010010 010010010010010010010010010010010 agile ecommerce d veloprnerit storeFront Consulting Installation Step by Step Instructions Note Due to the complexity of the extension installation is only supported via Magento Connect While it is possible to install the extension by copying files from the extension package directly to your Magento instance base folder this method is prone to error and can make uninstalling and upgrading the extension more difficult Note Magento Connect requires write permissions to your Magento instance files Write permission can be granted temporarily during the install and revoked after the installation is complete 1 Set your file system permissions to writable 777 for your Magento base folder and all sub folders and files Instructions on how to change your permissions can be found at Magento s official knowledge base http www magentocommerce com wiki groups 227 magento connect http www magentocommerce com wiki 1 installation and configuration magento filesystem permissions 2 Login to the Magento Admin panel 3 Navigate to System Magento Connect Magento Connect Manager August 17 2012 Magento Enterprise Dashboard Sales Catalog Mobile Customers Promotions Newsletter CMS Reports System 9 Get help for th
30. nt storeFront Consulting Order Integration Configuration Now navigate to DropShip Commerce gt Order Integration On this screen you will Enable Disable the Order Integration enter the SFTP credentials that the integration will upload Purchase Orders to and the Data On Demand Job ID s for triggering DropShip Commerce to process Purchase Order s once received in the SFTP account retrieve Order Status from DropShip Commerce and Tracking information once Purchase Orders have been shipped Dropship Commerce Magento Extension User Manual v1 0 8 1 25 NO d 101001001001001001007 0010010010010 010010010010010010010010010010010 VAD OAD O14 001004 Caile ecommerce development lt storeFront Consulting Order Integration Order Integration Enabled y GLOBAL Enable disable order integration SFTP Credentials O Server Address ftp dropship com GLOBAL Enter Hostname Username account1000000689 GLOBAL Enter SFTP username Password m GLOBAL Enter SFTP account password Orders In Job ID j50ec7d0220f1 8625592621 GLOBAL Enter the Orders In Data on Demand Job ID obtained from the Dropship Commerce platform You can obtain this Job ID from the end of the Data on Demand URL Order Status Out Job ID j50eed7cb5dd3c425032436 GLOBAL Enter the Order Status Out Data on Demand Job ID obtained from the Dropship Commerce platform You can obtain this Job ID from the
31. nto Connect Manager Magento MANAGER Log In Please re enter your Magento Adminstration Credentials Only administrators with full permissions will be able to log in Username Password Help Us to Keep Magento Healthy Report All Bugs Magento Connect Manager ver 1 7 0 0 Magento is a trademark of Magento Inc Copyright 2012 Magento Inc Dropship Commerce Magento Extension User Manual v1 0 8 1 91001001001001001001001001001001 010010010010010010010010010010010 1f agile ecommerce d v loprn rit storeFront Consulting 5 You will now need to upload the DropShip Commerce Magento Extension via the Direct Package File Upload option see below Click browse and select the Magento Extension file provided to you by DropShip Commerce and click Upload E MANAGER Extensions O store on the maintenance mode while installing upgrading backup creation lt lt O Create Backup Database H Search for modules via Magento Connect H Paste extension key to install C rect package file upload E Download or build package file 4 Upload package file Upload Manage Existing Extensions Check for Upgrades Channel Magento Community Edition Commit Changes Clear all sessions after successful install or upgrade Package Name Installed Actions Summary Interface Adminhtmi Default 1 7 0 0 stable gt Default interface for Adminhtmi Interface Fronten
32. on User Manual v1 0 8 1 15 010010010010010010010010010010010 010010010010010010010010010010010 FOOT OF OO1 02100 10 agile ecommerce development storeFront Consulting 3 Step 2 Settings Source Data Pick the source of products you wish to pull into Magento You can choose a single supplier all suppliers or a single assortment Check the Only include changes since last successful run box Select Download as the Destination Type Add an email address to receive failure notifications Click Next 4 Format 2 Settings 3 Schedule Export Source Source Data All Suppliers m V Only include changes since the last successful run Export Destination Destination ype Download f Failure Notifications Email Address Ir 4 Step 4 Schedule Click I m Done Dropship Commerce Magento Extension User Manual v1 0 8 1 16 010010010010010010010010010010010 010010010010010010010010010010010 AC OAD OAD OAD OADM agile ecommerce d velopmerit storeFront Consulting Order Integration Tracking Info A job needs to be created in the DropShip Commerce platform to allow for Magento to retrieve the tracking information of Purchase Orders from the DropShip Commerce platform 1 Click the Add Job button 2 Step 1 Format Type in Tracking Out for the Job Title Select Tracking Out for Job Type Select EDSS for the Platform Select 1 0 for the Platform Version Selec
33. p Commerce suppliers and configure which shipping methods are available for each Click on the button to Add New Supplier and enter all of the supplier information The supplier ID can be obtained from the URL when logged into the DropShip Commerce platform and browsing that Suppliers Inventory Add Supplier Back Supplier Name Supplier ID Street Address 4 Country Please Select gt Region State da u novads City Zip Postal Code On the Shipping Information Tab you can configure the shipping methods available to the supplier Just select the Shipping Carriers holding the ctrl key to select more than one and do the same for the Shipping Methods Shipping Methods will only appear for the Shipping Carriers selected Dropship Commerce Magento Extension User Manual v1 0 8 1 36 1010010010010010010010010010010010 010010010010010010010010010010010 1 C agile ecommerce d v lopment lt 1 storeFront Consulting Add Supplier X Shipping Carriers Fixed Free United Parcel Service Select the carriers for this supplier Shipping Methods United Parcel Service 3 Day Select Ground Canada Standard Dropship Commerce Magento Extension User Manual v1 0 8 1 37 1001001001001001001001001001004C 1001001001001001001001001001001C agile ecommerce d v lopment storeFront Consulting Product Feed Configurable Product Mapping The DropShip
34. pShip Commerce Platform Developer Documentation sssssssss 43 PREIS ESO MI 44 ilti mro c ES 44 Release RU C EE 45 Release WO E mE 45 EEN E ER 46 Dropship Commerce Magento Extension User Manual v1 0 8 1 3 010010010010010010010010010010010 010010010010010010010010010010010 57 f agile commerc d v lopmernt storeFront Consulting Overview Vendors Invoices 4 Product Data e Inventory Update DROPSHIP Order Status Order Tracki Ch DropShip Commerce is a robust and flexible platform with applications tuned specifically to address the needs of a virtual supply chain These applications are built on a SaaS based on demand platform The DropShip Commerce Connector for Magento enables product inventory and purchase order PO ordering integration between your Magento store and the DropShip Commerce platform Product Integration The DropShip Commerce Connector for Magento provides product data integration between the DropShip platform and your Magento store The product integration feature allows you to automatically populate your Magento catalog with product data from your supplier through the DropShip platform Dropship Commerce Magento Extension User Manual v1 0 8 1 4 010010010010010010010010010010010 010010010010010010010010010010010 f agile ecommerce d v lopment lt 1 storeFront Consulting
35. ry Out for the Job Title Select Inventory Out for Job Type Select EDSS for the Platform Select 1 0 for the Platform Version Select File Tab as the Method Click Next 2 Settings 3 Schedule Dropship Commerce Magento Extension User Manual v1 0 8 1 21 010010010010010010010010010010010 010010010010010010010010010010010 TAONANNANNANNAN NA ild ecommerce development storeFront Consulting 3 Step 2 Settings Source Data Pick the source of products you wish to pull into Magento You can choose a single supplier all suppliers or a single assortment Select Download as the Destination Type Add an email address to receive failure notifications Click Next 4 Format 2 Settings 3 Schedule Export Source source oat Auris s Only include changes since the last successful run Export Destination Destination ee Combed hh W Failure Notifications Emai address 4 Step 4 Schedule Click I m Done Dropship Commerce Magento Extension User Manual v1 0 8 1 22 CN IVW Y i LIU IY Y IY Y IVY Ad I ww IK 1010010010010010010010010010010010 3010010010010010010010010010010010 101001101011 agile ecommerce d v lopment N1 StoreFront Consulting URL s Now that you have all of the necessary jobs created you can obtain the Data On Demand ID s from each job and configure them in Magento To retrieve the Data On Demand ID just click on the ch
36. se Orders are processed through the DropShip platform their information is retrieved automatically and processed into Magento This occurs every hour at 40 minutes past the hour Information Retrieved Frequency Start Time PO Acceptance Line Item Status Line Item Status Reason Hourly 40 minutes past the Shipment Tracking hour Dropship Commerce Magento Extension User Manual v1 0 8 1 28 NO d 101001001001001001007 0010010010010 010010010010010010010010010010010 acta cao 5654105654 agil ecomrierce d v lopment lt 1 storeFront Consulting Inventory Integration Configuration Now navigate to DropShip Commerce gt Inventory Integration On this screen you will Enable Disable the Inventory Integration enter the Data on Demand Job ID to retrieve process the inventory feed and set the Processing Limit for the number of records the integration will process at a time Current Configuration Scope Inventory Integration Save Config Default Config Enter maximum inventory rows to process in one cron job run Enter 0 for no limit Dropship Commerce Magento Extension User Manual v1 0 8 1 29 510010010010010010010010010010010 O1 1001001001001001007 OO10010010010 A 1f agile ecommerce d v loprn rit storeFront Consulting Inventory Integration Configuration Setting Details General Inventory Integration Feed Schedule Frequency On Demand Inventory Out
37. ssing limit set in configuration Every time the Process Inventory Feed button is pressed it will only process the number of records configured You may need to process it several times to complete the entire inventory feed It is advised that you tail the log while processing this way so you know when it is complete Dropship Commerce Magento Extension User Manual v1 0 8 1 41 010010010010010010010010010010010 010010010010010010010010010010010 1f agile ecommerce d v loprn rit 1 storeFront Consulting Purchase Order PO Ordering Integration Manual Triggering Manually Sending Purchase Orders to DropShip Commerce When an order is placed on the Magento site a Purchase Order is created There are two ways to manually send Purchase Orders to DropShip from your Magento store Sending ALL Purchase Orders Navigate to the DropShip Commerce menu select Run Feeds and then click the Send All Purchase Orders button In order for Purchase Orders to be sent to DropShip Commerce their corresponding order must reside at the Processing order status and have not previously been sent Sending Selected Purchase Orders Navigate to the Sales menu select DropShip Commerce Purchase Orders Then select the Purchase Orders you would like to re send to the DropShip platform Select Send PO s from the Actions dropdown menu and finally click the Submit button Manually Retrieving Order Status Tracking Information Navigate to the DropS
38. t File Tab as the Method Click Next 2 Settings 3 Schedule Tracking Out Dropship Commerce Magento Extension User Manual v1 0 8 1 17 NO d 01 001001001001001001 0010010010010 010010010010010010010010010010010 TON OANA AO 4 agil commerc d v lopment storeFront Consulting 3 Step 2 Settings Source Data Pick the source of products you wish to pull into Magento You can choose a single supplier all suppliers or a single assortment Check the Only include changes since last successful run box Select Download as the Destination Type Add an email address to receive failure notifications Click Next 4 Format 2 Settings Export Source Source Data All Supplies s Only include changes since the last successful run Export Destination Destination Type Download Failure Notifications 4 Step 4 Schedule Click I m Done Dropship Commerce Magento Extension User Manual v1 0 8 1 18 010010010010010010010010010010010 010010010010010010010010010010010 1ANANNANNANNAN NA Cild ecommerce development C storeFront Consulting Product Integration A job needs to be created in the DropShip Commerce platform to allow for Magento to retrieve a products file from the DropShip Commerce platform for later processing on Magento s side 1 Click the Add Job Button 2 Step 1 Format Type in Product Out for the Job Title Select Product Out for Job
Download Pdf Manuals
Related Search