Our integration provides seamless product imports allowing you to manage your product data on Volusion while we automatically retrieve the latest changes on a daily basis.
Import products from Volusion
Reference: https://volusionhelpcenter.force.com/knowledgebase/s/article/GoDataFeedIntegrationWithVolusionAPI
1. Log on to your Volusion back-end administration
2. Click the 'Inventory' tab and then the Import/Export link under it
3. Click Volusion API
4. Check the Enable public XML for All Products. Generated once a day. option, then click Save next to it
5. Click run next to Generic/Products
6. Select the ProductCode field and all other fields you would like to use in your feeds; the recommended fields can be found below.
Recommended fields
p.ProductCode pe.Availabilitype.FreeShippingItempe.PhotoURL_Smallpe.ProductConditionpd.ProductDescriptionpe.ProductManufacturerpe.ProductNamepe.ProductNameShortpe.ProductPricepe.ProductWeightpe.SalePricep.StockStatuspe.UPC_codep.Vendor_PartNope.Yahoo_Category -OR- pe.Google_Product_Category -OR- pe.Google_Product_Type (whichever one contains the most relevant category data)All available fields
Below is the list of all fields available through the Volusion API. They can also be found in their documentation here.
p.AutoDropShipp.DisplayBeginDatep.DisplayEndDatep.DoNotAllowBackOrdersp.HideProductp.HomePage_Sectionp.IsChildOfProductCodep.IsChildOfProductCode_ProductIDp.LastModByp.LastModifiedp.Options_Cloned_Fromp.Options_Cloned_From_ProductIDp.Photos_Cloned_Fromp.Photos_Cloned_From_ProductIDp.ProductCodep.ProductIDp.ProductNamep.ProductPopularityp.Share_StockStatus_Withp.Share_StockStatus_With_ProductIDp.StockStatusp.Vendor_PartNop.WarehouseAislep.WarehouseBinp.WarehouseCustomp.WarehouseLocationpd.ProductDescriptionpd.ProductDescriptionShortpe.Accessoriespe.Additional_Handling_Indicatorpe.AddtoCartBtn_Replacement_Textpe.AddToPO_Nowpe.Affiliate_Commissionable_Valuepe.AllowPriceEditpe.Availabilitype.Book_ISBNpe.CustomField1pe.CustomField2pe.CustomField3pe.CustomField4pe.CustomField5pe.custom_label_0pe.custom_label_1pe.custom_label_2pe.custom_label_3pe.custom_label_4pe.DiscountedPrice_Level1pe.DiscountedPrice_Level2pe.DiscountedPrice_Level3pe.DiscountedPrice_Level4pe.DiscountedPrice_Level5pe.DiscountedRecurringPrice_Level1pe.DiscountedRecurringPrice_Level2pe.DiscountedRecurringPrice_Level3pe.DiscountedRecurringPrice_Level4pe.DiscountedRecurringPrice_Level5pe.DiscountedSetupCost_Level1pe.DiscountedSetupCost_Level2pe.DiscountedSetupCost_Level3pe.DiscountedSetupCost_Level4pe.DiscountedSetupCost_Level5pe.DownloadFilepe.EnableMultiChildAddToCartpe.EnableOptions_InventoryControlpe.EstShip_2ndDaype.EstShip_Groundpe.EstShip_Overnightpe.Fixed_ShippingCostpe.Fixed_ShippingCost_Outside_LocalRegionpe.FreeShippingItempe.GiftWrapCostpe.Google_Adult_Productpe.Google_Age_Grouppe.Google_Availabilitype.Google_Colorpe.Google_Genderpe.Google_Materialpe.Google_Patternpe.Google_Product_Categorype.Google_Product_Typepe.Google_Sizepe.Google_Unique_Identifier_Existspe.Heightpe.Hide_FreeAccessoriespe.Hide_When_OutOfStockpe.Hide_YouSavepe.HowToGetSalePricepe.Inv_LastVerifiedpe.Inv_Verify_QtyOnHandpe.LastPO_Datepe.LastPO_Qtype.Lengthpe.ListPricepe.ListPrice_Namepe.MaxQtype.METATAG_Descriptionpe.METATAG_Titlepe.MinQtype.Oversizedpe.Package_Typepe.Photo_AltTextpe.Photo_SubTextpe.PhotoURL_Largepe.PhotoURL_Smallpe.Price_SubTextpe.Price_SubText_Shortpe.Private_Section_Customers_Onlype.ProductCategorype.ProductConditionpe.ProductKeywordspe.ProductManufacturerpe.ProductNameShortpe.ProductPricepe.ProductPrice_Namepe.ProductWeightpe.Quickbooks_Item_Accntpe.Quickbooks_Item_AssetAccntpe.Quickbooks_Item_CogsAccntpe.Recurring_Pricing_Textpe.RecurringDurationpe.RecurringHowOftenpe.RecurringPricepe.RecurringStartDurationpe.RecurringStartPricepe.Reward_Points_Given_For_Purchasepe.SalePricepe.SalePrice_Namepe.SelectedOptionIDspe.SetupCostpe.SetupCost_Namepe.SetupCost_Titlepe.Ships_By_Itselfpe.ShoppingDotCom_Categorype.StockLowQtyAlarmpe.StockReOrderQtype.TaxableProductpe.UPC_codepe.Uses_Product_KeyTypespe.VAT_Percentagepe.Vendor_Pricepe.warehousespe.Widthpe.Yahoo_Categorype.Yahoo_Mediumpm.CUSTOM_METATAGS_OVERRIDEpm.ExtInfopm.METATAG_Keywordspm.OrderFinished_Notepm.ProductDescription_AbovePricingpm.ProductFeaturespm.TechSpecs7. Select the HideProduct field and enter the value Null in the WHERE_Value textbox
Note: If your products are importing but showing 0 or only 100 products, it is because you missed Step 7.
8. Click run; this will generate an HTTP path to access the product data
9. Log on to your GoDataFeed account and go to the Import tab from the top navigation
10. Select Primary Source
11. In the Import Source drop-down, select Volusion
12. Enter your store's API Path and Base URL
13. Save -- now you may import your products
Note: The more fields you use in your feed, the more complete your data will be. More complete feed data can improve product visibility.
Troubleshooting a decrease in products at the import level
Visible vs Hidden Products
When updating your API path, the number of products that the user has may decrease. Therefore, you may need to verify that their API path includes the following:
- The column &p.HideProduct,
- The following where clauses:
- &WHERE_Column=p.HideProduct&WHERE_Value=null
The above specifies whether the user wants to import hidden products vs visible products.
Product Filter
If the user has added the p.HideProduct and the WHERE clause and the problem persists, there is one more thing to look at. The API path contains a product filter that has two names. This filter can be known as EDI_Name or API_Name. This filter can have 2 values:
- Generic\Products
- Generic\All_products
The default value is Generic/Products and changing the value to Generic\All_products will enable the user to import the missing products.
Comments
0 comments
Please sign in to leave a comment.