Forum Replies Created

Viewing 15 replies - 31 through 45 (of 153 total)
  • Hi. Thanks for this great plugin!

    Where can I download spanish translation?

    I don’t understand how translate.wordpress.org works.

    Thanks in advance.

    I followed this link to this post and the solution proposed by Alatus does the trick for me too.

    I’m having same issue. If I deactivate your plugin, the warning message disappears.

    Are you sure that this is only a WPML problem?

    Thanks in advance.

    Thread Starter chavo

    (@chavo)

    Hi. When I select the input checkbox to disable menu item, my choice isn’t saved. Checkboxes remain unchecked. Any advice on this?

    Thanks in advance

    Thread Starter chavo

    (@chavo)

    Sorry. I went out for weekend. Thanks for your reply!

    Hi. Same problem here. I can’t get the Secondary Title column in post type admin list.

    Thread Starter chavo

    (@chavo)

    The problem was with sticky posts.

    Thread Starter chavo

    (@chavo)

    Well…after a lot of research, I figured out which line I have to change.

    Supertheman7: your comment helps me but doesn’t do the job. The line that is necessary to change is another.

    So, for those who are looking for a solution, here it is…

    Look at these line:

    while ( count($rows) < 5 && ( $data = fgetcsv($handle) ) !== FALSE ) {

    and change it like this:

    while ( count($rows) < 5 && ( $data = fgetcsv($handle, filesize( $handle ), ";" ) ) !== FALSE ) {

    Also, make the delimiter change mentioned originally.

    Thread Starter chavo

    (@chavo)

    Well, I figured out how to make my custom admin products report list with css style. Here is my custom code for those who want to take a look (somo words are in spanish but nothing difficult).

    Use it in your wpsc-email_style_purchase_report.php template:

    <?php
    $purchaseID = ECSE_purchase::get_the_purchase_ID(); 
    
    global $wpdb;
    
    $cartsql = $wpdb->prepare( "SELECT * FROM <code>" . WPSC_TABLE_CART_CONTENTS . "</code> WHERE <code>purchaseid</code>=". $purchaseID . "", $purchase['id']);
    $cart_log = $wpdb->get_results( $cartsql, ARRAY_A );
    $j = 0;
    // /*
    if ( $cart_log != null ) { ?>
    <table width="700" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <th colspan="2" scope="col" align="left" valign="top" style=" padding: 10px 0; color:#004796; font-family:Arial, Helvetica, sans-serif; font-size:13px; line-height:13px; border-bottom: solid 1px #CCC;">Producto</th>
        <th width="120" scope="col" align="center" valign="top" style="padding: 10px; color:#004796; font-family:Arial, Helvetica, sans-serif; font-size:13px; line-height:13px; border-bottom: solid 1px #CCC;">Código</th>
        <th width="60" scope="col" align="center" valign="top" style="padding: 10px 0; color:#004796; font-family:Arial, Helvetica, sans-serif; font-size:13px; line-height:13px; border-bottom: solid 1px #CCC;">Cant.</th>
        <th width="90" scope="col" align="right" valign="top" style="padding: 10px 0 10px 10px; color:#004796; font-family:Arial, Helvetica, sans-serif; font-size:13px; line-height:13px; border-bottom: solid 1px #CCC;">Precio</th>
        <th width="90" scope="col" align="right" valign="top" style="padding: 10px; color:#004796; font-family:Arial, Helvetica, sans-serif; font-size:13px; line-height:13px; border-bottom: solid 1px #CCC;">Total</th>
      </tr>
    <?php
    
    $gsttotal = false;
    $endtotal = $total_shipping = 0;
    foreach ( (array)$cart_log as $cart_row ) {
    	$alternate = "";
    	$j++;
    	if ( ($j % 2) != 0 )
    	$alternate = "alt";
    	$variation_list = '';
    
    	$billing_country = !empty($country_data[0]['value']) ? $country_data[0]['value'] : '';
    	$shipping_country = !empty($country_data[0]['value']) ? $country_data[0]['value'] : '';
    
    	$shipping = $cart_row['pnp'];
    	$total_shipping += $shipping;
    
    	$prodID = $cart_row['prodid'];
    ?>
      <tr>
        <?php // PRODUCTO ?>
        <td width="50" align="left" valign="top" style="padding: 10px 0; border-bottom: dotted 1px #CCC;">
    <?php
    // levanto la imagen
    $item_img = '<img class="product_image" title="'.$cart_row['name'].'" alt="'.$cart_row['name'].'" src="'.get_template_directory_uri().'/timthumb/timthumb.php?src='.wpsc_the_product_image('','', $prodID).'&w=48&h=48&zc=2" style="border:solid 1px #ccc">';
    echo $item_img;
    ?>
    </td>
        <td width="290" align="left" valign="top" style="padding: 10px 0 10px 10px; color:#004796; font-family:Arial, Helvetica, sans-serif; font-size: 12px; line-height: 15px; border-bottom: dotted 1px #CCC;">
    <?php
    // nombre de producto
    echo apply_filters( 'the_title', $cart_row['name'] );
    echo $variation_list;
    ?>
    </td>
    <?php // CÓDIGO DE PRODUCTO ?>
        <td width="120" align="center" valign="top" style="padding: 10px; color:#666; font-family:Arial, Helvetica, sans-serif; font-size: 12px; line-height: 15px; border-bottom: dotted 1px #CCC;">
    <?php
    $sku = get_post_meta($prodID, '_wpsc_sku' , true);
    echo $sku;
    ?>
    </td>
    <?php // CANTIDAD ?>
        <td width="60" align="center" valign="top" style="padding: 10px 0; color:#666; font-family:Arial, Helvetica, sans-serif; font-size: 12px; line-height: 15px; border-bottom: dotted 1px #CCC;">
    <?php
    echo $cart_row['quantity'];
    ?>
    </td>
    <?php // PRECIO UNITARIO ?>
        <td width="90" align="right" valign="top" style="padding: 10px 0 10px 10px; color:#666; font-family:Arial, Helvetica, sans-serif; font-size: 12px; line-height: 15px; border-bottom: dotted 1px #CCC;">
    <?php
    $price = $cart_row['price'] * $cart_row['quantity'];
    echo wpsc_currency_display( $price );
    ?>
    </td>
    <?php // PRECIO ITEM TOTAL ?>
        <td width="90" align="right" valign="top" style="padding: 10px; color:#666; font-family:Arial, Helvetica, sans-serif; font-size: 12px; line-height: 15px; border-bottom: dotted 1px #CCC;">
    <?php
    $endtotal += $price;
    echo wpsc_currency_display( ($price ), array('display_as_html' => false)  );
    ?>
    </td>
      </tr>
    <?php } ?>
    </table>
    <?php // TOTAL  ?>
    <table width="700" border="0" cellpadding="0" cellspacing="0">
    <tr>
    <td width="360" align="left" style="color:#004796; font-family:Arial, Helvetica, sans-serif; font-size: 14px; line-height:14px; font-weight: bold; border-bottom: dotted 1px #CCC;">TOTAL <small style="color:#666; font-family:Arial, Helvetica, sans-serif; font-size: 12px; font-weight: normal;">(no incluye impuestos)</small></td>
    <td width="340" align="right" style="padding: 10px; color:#666; font-family:Arial, Helvetica, sans-serif; font-size: 14px; line-height:14px; border-bottom: dotted 1px #CCC; font-weight: bold;">
    <?php
    $endtotal += $purchase['wpec_taxes_total'];
    echo wpsc_currency_display( $endtotal , array('display_as_html' => false) );
    ?>
    </td>
    </tr>
    </table>
    <?php } ?>
    Thread Starter chavo

    (@chavo)

    What a jerk! I confused XML with XLS when I read the file extesions that the plugin supports.

    Thread Starter chavo

    (@chavo)

    Thank you. I wrote a support ticket to http://www.varktech.com also.

    The discount is also applied to total price (subtotal + taxes).

    Thread Starter chavo

    (@chavo)

    Bump. Anyone?

    Thread Starter chavo

    (@chavo)

    🙁

    Hi Jacob. Thanks for your reply!

    I’m trying to figure out how to get that the product list in admin emails matches with the aesthetics of checkout/transaction report pages. It’s a hard goal because of the plain html that outputs purchase-log-notification.class.php. Also I’m taking a look if based in your plugin I can developt my own function making sql queries but I’m not a code master, just a graphic / web designer with intermediate programming skills.

    It will be really useful if you can add admin emails content templating in a next release. Anyway, once again: great job!

    Thread Starter chavo

    (@chavo)

    Well, I don’t know if is the best solution, but a I get it!!!
    I took a look at the database and I noticed that the “post_parent” value is what I have to obtain because each item has a different product ID based on variations but “post_parent” remains the same.

    So, reading a little at this link I tried:

    <?php
    $product_id = wpsc_cart_item_product_id(); //find product id
    $parent = $wpdb->get_var( $wpdb->prepare("SELECT post_parent FROM $wpdb->posts WHERE ID = %d", $product_id ) ); // find post_parent based on product_id
    echo $sku = get_post_meta($parent, '_wpsc_sku' , true); // print sku based on post_parent ID
    ?>

    It works!

    Thread Starter chavo

    (@chavo)

    Oh, my fault!!! I have discovered how to do it.

    Just disable “Use Shortlink?” before publishing post.

Viewing 15 replies - 31 through 45 (of 153 total)