HomeHome Product Discus... Product Discus...RazorCartRazorCartSmithCart & Razor Cart CSV Export ErrorsSmithCart & Razor Cart CSV Export Errors
Previous
 
Next
New Post
11/16/2017 11:08 PM
 
Hi There. I am in the process of upgrading our one client from smith to razor cart across two different brands. However, the problem comes in with the CSV export of the smith cart product. The CSV comes out in such a mess under the description tabs that it's almost impossible to tell where a product starts and ends.

The product clean up within the CSV is not possible due to the above issue and we are dealing with around 250 products for the one client and 3500 for another.

Please could you provide a solution for this as trying to go through the CSV manually is not a viable option due to the sheer number of products, descriptions, summaries, etc... that are involved.

It seems as though any HTML added into the tabs is what is causing the CSV files to break and prepend the content onto new lines and jumbling up all the content.

I look forward to your response.
 
New Post
11/17/2017 12:14 PM
 
Hi Michele,

  1. Install RazorCart
  2. Create a store using the Admin-Console (1st created store will have StoreID = 1, if not sure the url will end with the store id: “/DesktopModules/RazorCart/AdminConsole/Home/Index/1”)
  3. Run the following in DNN SQL Console to link the old tables with the created StoreID

DECLARE @StoreID INT = 1

UPDATE {databaseOwner}{objectQualifier}Smith_Products SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ProductTemplate SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Category SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_EmailCampaign SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Coupons SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Customer SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_EmailTemplateSC SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShipCategories SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShipFree SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShipMethods SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_InvoiceTemplate SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShippingByAmount SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShippingByQuantity SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShippingByWeight SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Manufacturer SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShippingByZipCode SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Analytics SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShipZone SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_OrderDiscounts SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_PayHist SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_StoreOrders SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_PaymentMethodsZones SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_PriceClass SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_SubscriptionSC SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Tax SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_TaxStates SET StoreID = @StoreID

 

Please let me know if you have any further questions.

At your service, 

Kelli, SC

Kelli Kropko
Licensing and Marketing
949.218.9600
 
Previous
 
Next
HomeHome Product Discus... Product Discus...RazorCartRazorCartSmithCart & Razor Cart CSV Export ErrorsSmithCart & Razor Cart CSV Export Errors