| Important Notes: This extension is deprecated. |
Total Import helps you to import product feed into your cart.
AbanteCart v1.2.10 – v1.2.13 use Total Import v1.2.0
Overview
NOTES:
Setup
1. Click this to go to Total Import settings page.
2. Turn ON the extension to start using the extension.
3. Notification that cron job has started: Turn ON to receive email notification cron job has started.
4. Disable product that contains these words in description, ingredients: Enter the keywords that will use to set the product status to disable. Separate the keywords by using comma (,).
5. Turn ON to update product image: If this is turned ON, ALL of the product images will be replaced each time the import run. Must be ON to use custom image.
6. To use your custom image for custom_no_image: Enter the image URL. This will be used as the product image when your product feed image URL column value is empty. Upload the desired image to public_html/your-store/image folder. Recommended file name is custom_no_image.jpg. Leave it empty to use the default empty image file that was provided by the extension.
7. Select appropriate server timezone: You need to set the correct timezone in order to get cron jobs run correctly. Please ask your hosting provider for more details about the timezone.
Settings
1. This is the default import profile that was shipped with this extension.
2. Click this button to go to step 1 page.
3. Click this button to go to step 2 page.
4. Click this button to go to step 3 page.
5. Click this button to go to step 4 page.
6. Click this button to go to step 5 page.
7. These are the manual link for each step.
8. Click here to view Total Import Log file.
2. Click this button to go to step 1 page.
3. Click this button to go to step 2 page.
4. Click this button to go to step 3 page.
5. Click this button to go to step 4 page.
6. Click this button to go to step 5 page.
7. These are the manual link for each step.
8. Click here to view Total Import Log file.
Import Step 1
Feed Source
Available feed format options.
1. Go here if you want to import via file upload method.
2. Go here if you want to directly import the feed via source URL method.
3. Go here if you want to directly import the feed via FTP.
4. Go here if you want to directly import the feed via your hosting filesystem.
Feed Format
Available feed format options.
CSV field Delimiter
These are the delimiter options for CSV feed, choose one according to your feed delimiter. Most feeds are using comma (,) delimiter. Ask your supplier if you are not sure which delimiter they use.
Via File Upload
1. Import Feed File: Click the choose file button to upload your feed.
Via URL
1. Import Feed URL: Enter the complete feed URL along with the filename. e.g. http://your-supplier-name.com/feed-name.csv or http://your-supplier-name.com/feed-name.xml.
Via FTP
1. FTP Server: Enter the FTP URL.
2. Username: Enter the FTP username.
3. Password: Enter the FTP password.
4. Absolute path to file: Enter the complete folder name along with the filename. e.g. /public-html/feed-folder/feed-name.csv or /public-html/feed-folder/feed-name.xml.
Via Filesystem
1. Import Feed Local File Path: Enter the complete feed location within your hosting along with the filename. e.g. /public-html/feed-folder/feed-name.csv or /public-html/feed-folder/feed-name.xml.
Advanced Settings
Notes: Number 1-3 is shown only if you are using URL as the feed source. And number 4-5 is shown if you are using CSV as the feed source.
1. Use Basic Authentication: Check this option if you are required to login into the URL source in order to obtain the feed.
2. Username: Enter your username.
3. Password: Enter your password.
4. First Row Is Headings: Check this if first row of your csv feed is used as the heading.
5. Use Safe Headings: Ignore the feed’s headings, use numbered columns instead.
6. Unzip Feed: Check this if your feed is zipped and the extension will unzip your feed and process it.
7. File Encoding: Select the appropriate file encoding of your feed. Mostly use UTF-8.
UTF-8: Select this to use UTF-8.
ISO-8859-1: Select this to use ISO-8859-1.
US-ASCII: Select this to use US-ASCII.
GB18030: Select this to use GB18030.
8. Cron Fetch: Check this if you want to use cron job to fetch your feed. It will get the first three items in your feed to configure your settings. This option is recommended for large products feed.
Import Step 2
1. Download remote images:
Yes: Select Yes if you want to download images from the provided URL within your feed.
No: Select No if you have images within your resources/image folder.
2. your image folder name where you upload them to under the resources/image folder: Leave it blank if you download remote images. (This field is shown if you choose No for number 1 above).
3. Image subfolder name: Enter the folder name that you want to use as a temporary download remote images folder within your hosting/resource/image (This field is shown if you choose Yes for number 1 above).
4. Skip importing empty quantity product’s: Select Yes if you want to skip importing empty quantity product’s and No to import them.
Yes: Select Yes if you want to skip importing empty quantity products.
No: Select No if you want to import empty quantity products.
5. Select start of the product discount price date: Will be used as the starting date of the discount price. Leave this field empty if there are no discount set in the feed.
6. Select end of product discount price date: Will be used as the end date of the discount price. Leave this field empty if there are no discount set in the feed.
7. Select the special price calculation type: Select percentage if you want to calculate the special price based on percentage or fixed price if you want to set the special price to fixed price.
Fixed price: Select this if the feed is using fixed special price.
Percentage: Select this if the feed is using percentage based special price.
8. Select start of the product special price date: Will be used as the starting date of the special price. Leave this field empty if there are no discount set in the feed.
9. Select end of product special price date: Will be used as the end date of the special price. Leave this field empty if there are no discount set in the feed.
10. Set Out of stock status: Select Out of stock status for empty product’s quantity.
11. Subtract Stock: Select Yes if you want to subtract stock and No to disable subtract stock.
12. Requires Shipping: Select Yes if the product requires shipping and No if the product doesn’t require shipping (such as downloadable product).
13. Minimum quantity: Enter the minimum purchased quantity.
14. Product Status: Select enabled to set the product status to active and disabled to inactive.
15. Weight Class: Select the default weight class for your product.
16. Length Class: Select the default length class for your product.
17. Tax Class: Select the default tax class for your product.
18. Customer group: Select the customer group that are eligible to get the discounts or product special price of your product.
19. Add product’s to:
All Categories: Select this if you want to assign the product to parent category and subcategory.
Sub Category Only: Select this if you want to assign the product to subcategory only.
20. Category Delimiter: Enter the field delimiter that will be used to set category and subcategory. This is used if your feed puts the category and subcategory name into one column.
21. Set the SEO Keyword for New Categories to:
Blank: Select this if you don’t want to set categories SEO keyword.
Category Name: Select this if you want to use Category Name as the SEO keyword for new categories.
22. Related products field: This is only can be used if you are updating the products and the model or ID exists within your store.
Model: Select this if you want to use Model as the related product’s key.
Product ID: Select this if you want to use Product ID as the related product’s key.
23. Related product’s Delimiter: Enter the field delimiter that will be used to separate between multiple product relation. 24. Stores: Select the store name that you want to import the product’s into. Currently this extension only works on single store.
Import Step 3
Fields
1. View Next Row: Click this button to see next row product information.
2. These are the available operations.
3. Select the desired operation first then click on this button to add the new operation.
Operations
1. Adjust field by percentage (discount/tax):
A. Adjust: Select the column name where the value will be adjusted by the second field value.
B. by: Enter the desired percentage value that will be used to calculate the source.
2. Adjust price by multiply:
A. Multiply (this field as source): Select the column name where the value will be multiplied by the second field.
B. with: Select the column that will be used as the multiplier.
3. Adjust price by add:
A. Add: Enter the value that will be added to the second field.
B. to: Select the column name where the value will be summed up with the first field value.
4. Filter products (equals):
A. Exclude products where: Select the column name where the value equals to the keyword that was defined in second field.
B. equals to: Enter the keyword that will used to filter. If it is matched, the product will be excluded from import.
5. Filter products (not equals):
A. Exclude products where: Select the column name where the value doesn’t equal to the keyword that was defined in second field.
B. does not equals to: Enter the keyword that will used to filter. If it is matched, the product will be excluded from import.
6. Append text to any field:
A. Append: Enter the desired text that will appended to second column name value.
B. after: Select the column name that will be appended.
7. Prepend text to any field:
A. Prepend: Enter the desired text that will prepended to second column name value.
B. to: Select the column name that will be appended.
8. Multiply any field:
A. Multiply (this field as source): Select the column name where the value will be multiplied with the second field.
B. with: Enter the value that will be used as the multiplier.
9. Add to any field:
A. Add: Enter the value that will be added to the second field.
B. to: Select the column name where the value will be summed up with the first field value.
10. Split any field:
A. Split: Select the column name that you want to split into new columns.
B. by: Enter the separator that will be used to separate the values.
11. Replace text:
A. Replace: Enter the keyword that should be replaced.
B. with: Enter the desired text that will be used to replace the keyword with.
C. in: Select the column name where the value the value will be replaced.
12. Convert newlines to HTML line break:
in: Select the column name that has new lines to be converted into html line break.
13. Remove text:
A. Remove: Enter the keyword here.
B. in: Select the column name that contain the keyword.
14. Filter products (containing):
A. Exclude products where: Select the column name where the value that contains the keyword that was defined in second field.
B. contains: Enter the keyword that will used to filter. If it is matched, the product will be excluded from import.
15. Filter products (not containing):
A. Exclude products where: Select the column name where the value doesn’t contain the keyword that was defined in second field.
B. does not contain: Enter the keyword that will used to filter. If it is matched, the product will be excluded from import.
16. Clone field:
A. Clone: Select the column name that will be cloned.
B. to: Enter the new column name for the cloned field.
17. Append field to field:
A. Append: Select the column name where the value will be appended to second column name value.
B. to: Select the column name where the value will be appended.
C. separated by: Enter the separator to separate source and target.
18. Merge option columns: This is used to create a new column that contains the merged product options
A. Option name: Enter the desired column name that will be used to contain the merged product option.
B. Base column: Select the base column name. It will placed in front of other product options.
C. Merge the following fields: Select the column name that contain the product option that will added to base column.
D. More: Click this to add more option.
e.g.: The feed has several product options columns, such as size and color. You want to create a new column called product options. In Option name field enter product options, select ‘size’ as the base column, and in the merge the following fields select ‘color’. If you have other product options, click the more button and select the column name.
19. Create custom column:
A. New column name: Enter the desired column name.
B. New column value: Enter the column value.
Import Step 4
Field Mapping
General
1. Simple Stock Update: Select Yes if you want to update product qty, price, cost, status, special price and discount price only or No if you want to update all fields.
2. Name: Select the appropriate column name that will be used as the product name.
3. Description: Select the appropriate column name that will be used as the product description.
4. Ingredients: Select the appropriate column name that will be used as the product ingredients. It will be added into product description.
5. Country of Origin: Select the appropriate column name that will be used as the product’s Country of Origin. It will be added into product’s description.
6. Meta Description: Select the appropriate column name that will be used as the product’s Meta Description.
7. Meta Keywords: Select the appropriate column name that will be used as the product Meta Keywords.
Data
1. Model: Select the appropriate column name that will be used as the product model.
2. SKU: Select the appropriate column name that will be used as the product SKU.
3. price: Select the appropriate column name that will be used as the product price.
4. Cost: Select the appropriate column name that will be used as the product cost.
5. Quantity: Select the appropriate column name that will be used as the product quantity.
6. Minimum Quantity: Select the appropriate column name that will be used as the product minimum quantity. It will override the minimum quantity that was set in step 2.
7. Subtract Stock: Select the appropriate column name that will be used to set if the product quantity should be subtracted or not. It will override the subtract stock setting that was set in step 2.
8. Requires Shipping: Select the appropriate column name that will be used to set if the product requires shipping or not. It will override the requires shipping setting that was set in step 2.
9. SEO keyword: Select the appropriate column name that will be used as the product SEO keyword.
10. Out of Stock status: Select the appropriate column name that will be used as the product’s Out of Stock Status. It will override the Out of Stock Status setting that was set in step 2.
11. Date Available: Select the appropriate column name that will be used as the product’s add date.
12. Image: Select the appropriate column name that will be used as the product main image. If you set NO on download remote images in step2, the column should be just the image filename only, and if you set YES, the column should contain the image URL.
13. Length: Select the appropriate column name that will be used as the product length.
14. Height: Select the appropriate column name that will be used as the product height.
15. Width: Select the appropriate column name that will be used as the product width.
16. Weight: Select the appropriate column name that will be used as the product weight.
17. Product Status: Select the appropriate column name that will be used to set the product status. It will override the product’s status setting that was set in step 2.
18. Sort Order: Select the appropriate column name that will be used to set the product sort order.
Tags
1. Product Tags: Select the appropriate column name that will be used as the product tag.
2. More: Click the more button if you have more than one product tag.
Links
1. Manufacturer: Select the appropriate column name that will be used as the product manufacturer or brand.
2. Category: Select the appropriate column name that will be used as the product category.
3. Subcategory: Select the appropriate column name that will be used as the product subcategory.
4. Click this button to add more sub category.
5. Click this button to add more category.
6. Related Products: Select the appropriate column name that will be used as the product relation. This should be used only for updating product as it requires product model or ID as the relation key.
Option
1. Options: Select the appropriate column name that will be used as the product option.
2. More: Click the more button if you have more than one product option.
Discount
1. Discount price: Select the appropriate column name that will be used as the product discount price. If you didn’t define the start and end date in step 2. The extension will automatically set 1 month expiry by using the current month.
2. More: Click the more button if you have more than one discount price.
Special
1. Special price: Select the appropriate column name that will be used as the product’s special price. If you didn’t define the start and end date in step 2. The extension will automatically set 1 month expiry by using the current month.
2. More: Click the more button if you have more than one special price.
Additional Image
1. Additional Image: Select the appropriate column name that will be used as the product’s additional image. If you set NO on download remote images in step2, the column should be just the image filename, and if you set YES, the column should contain the image URL.
2. More: Click the more button if you have more than one additional image.
Stock Update Field Mapping
Simple Fields
1. Quantity: Select the appropriate column name that will be used as the product quantity.
2. price: Select the appropriate column name that will be used as the product price.
3. Cost: Select the appropriate column name that will be used as the product cost.
4. Product Status: Select the appropriate column name that will be used to set the product status. It will override the product status setting that was set in step 2.
5. Special price: Select the appropriate column name that will be used as the product’s special price. If you didn’t define the start and end date in step 2. The extension will automatically set 1 month expiry by using the current month.
6. More: Click the more button if you have more than one special price.
7. Discount price: Select the appropriate column name that will be used as the product discount price. If you didn’t define the start and end date in step 2. The extension will automatically set 1 month expiry by using the current month.
8. More: Click the more button if you have more than one discount price.
Simple Update Matching Field
1. Model: Select the appropriate column name that will be used as for matching the existing product model.
2. SKU: Select the appropriate column name that will be used as for matching the existing product SKU.
Import Step 5
1. Quick Note: Click this to bring up the quick note.
2. Manual Link: Click this to bring up the quick note.
3. Profile Name: Enter the desired profile name that will be saved and used for cron job.
4. Apply: Click this button to apply the current settings.
5. Save: Click this button to save the current settings into the profile name.
6. Download: Download the current settings into csv file for backup.
7. Go back one page: Click this button to go back to step4 settings page.
8. Click here to go to extension settings page.
9. Table Reset: Click here to open the table reset selection.
10. Select tables to reset: We recommend you to use a cron job if you have large size of products
A.Products: Check this to empty the products table.
B.Categories: Check this to empty the categories table.
C.Manufacturers: Check this to empty the manufacturers table.
D.Options: Check this to to empty the product options table
11. New Items:
A.Add: Select this if you want to Add new products.
B.Skip: Select this if you want to skip adding new products
12. Existing Items:
A.Update: Select this if you want to update existing products.
B.Skip: Select this if you want to skip update existing products
13. Identify Existing Products by Matching field:
A.Model: Select this if you want to identify Existing Products based on product model.
B.SKU: Select this if you want to identify Existing Products based on product sku.
14. Items in store but not in file:
A.Ignore: Select this to ignore / keep the products in your store.
B.Delete: Select this to delete the products that was not in the feed.
C.Disable: Select this to disable the products that was not in the feed.
D.Quantity to zero: Select this to set the products quantity that was not in the feed to zero.
15. Products per import segment: This is how many products will be imported for each segment of the import. If you are experiencing issues with timeouts, then set this value lower.
16. Items to Import:
A.All: Select this if you want to import all.
B.Range: Import only part of your product feed e.g.: From 1 to 100 will import the first 100 items in your file
View Log
1. Each Tab title represent the import job date based.
2. The logs are written here.
Additional
Excluded Products
1. Excluded Products: Click this menu item to open the excluded products that was set in step 2 page.
2. Products List: These are the list of products that was excluded and set to disabled.
3. The toolbars functions are similar to default toolbar in products page where you can search for products that contain certain words.
4. Click this to select whether you want to take a quick view of products in a popup or go to products detail page.
5. Click this button to save current row changes.
Export Order
1. Export Order: Click this menu item to open the export order page.
2. Date Range: You can select the range date of the report. Available range dates are:
2.1. Today: Choose this if you want to only retrieve today Sales Order Report.
2.2. Yesterday: Choose this if you want to retrieve yesterday Sales Order Report.
2.3. Last 7 Days: Choose this if you want to retrieve last 7 days Sales Order Report.
2.4. Last week (Sun-Sat): Choose this if you want to retrieve last week Sales Order Report.
2.5. Last business week (Mon-Fri): Choose this if you want to retrieve last business week Sales Order Report.
2.6. This Month: Choose this if you want to retrieve this month Sales Order Report.
2.7. Last Month: Choose this if you want to retrieve last month Sales Order Report.
2.8. Custom Range Date: Choose this if you want to retrieve Sales Order Report based on your selection date.
3. Date Start: You can choose your desired start date to retrieve the Sales Order Report.
4. Date End: You can choose your desired end date to retrieve the Sales Order Report.
5. Order Status: You can choose which Order Status that you want to be shown for the reports (If left blank, it uses the ALL as a default):
5.1. Canceled
5.2. Canceled by Customer
5.3. Canceled Reversal
5.4. Chargeback
5.5. Completed
5.6. Denied
5.7. Failed
5.8. Incomplete
5.9. Payment Verified (this is added by the extension)
5.10. Pending
5.11. Processed by Warehouse (this is added by the extension)
5.12. Processing
5.13. Refunded
5.14. Reversed
5.15. Shipped
5.16. Submitted to Warehouse (this is added by the extension)
6. Click this to filter the orders.
7. Export To:
CSV: This will export to csv format.
XLS: This will export to xls format.
XLSX: This will export to xlsx format.
8. Click this to export the orders.
9. Click this to view the order detail.
10. Click this to view the product detail.
Payment Verification
1. Payment Verification: Click this menu item to open the payment verification page.
2. Select the order status that you want to see and click on the GO button
3. The toolbars functions are similar to default toolbar in order page where you can search for orders by entering the keywords within the columns field.
4. This is the orders list.
5. Enter your desired comment in this textarea. This is useful if you want to let other department knows that the money is received.
6. Click the edit button to go to the order detail page if you want to add some more comments.
7. Click the save button if you want to change the order status and the comment.
Setup Cron Job
Important Notes: You need to understand how to setup a cron job prior enter the appropriate command. Click here for more information about how to setup cron job.
1. Enter the following command into your cron job command in order to import the products:
/usr/local/bin/php public_html/installation_folder/extensions/total_import/cron_task.php profile_name start_number-end_number.
2. Replace installation_folder with the folder name where your cart is installed.
3. Replace profile_name with your saved profile name.
Notes: start_number-end_number is optional.
4. Replace start_number with which line number of the feed should be start importing.
5. Replace end_number with which line number of the feed should be stop being imported.
6. e.g. /usr/local/bin/php public_html/store/extensions/total_import/cron_task.php productfeed 1-100. The extension will get the productfeed settings and import only the first 100 items from the feed.
Changelog
v1.2.0
2018 – 10 – 10
Initial Release for Abantecart v1.2.10 – v1.2.13.